output / @identity values in mysql

Anon

Dear esteemed friends and other great minds:

in MSSQL I can do the following:

@Project_Owner = 1,
@Project_Name = test_project,
@Project_Id = @@IDENTITY;
INSERT INTO PROJECTS (Project_Owner, Project_Name)
Values (@Project_Owner,
@Project_Name)
SELECT @Project_Id = @@IDENTITY
INSERT INTO USER_XREF (Project_Id,User_Id)
Values (@Project_Id, @Project_owner);

How can I do this in mySQL?
Is there any similar method of getting the id of an inserted record and then using that id in immediate subsequent inserts?

~ OK

"How sweet is mortal Sovranty!"---think some:

Others---"How blest the Paradise to come!"

Ah, take the Cash in hand and waive the Rest;

Heed not the music of a distant Drum!"

Anon

http://www.php.net/manual/function.mysql-insert-id.php

right there in the docs 🙂

Anon

thanks but,

I want to do it in mysql itself, in the sql statement just like i can so easily do in mssql. maybe its not possible. but that would be sad.

~ OK

Anon

That <i>is</i> "mysql itself". These things are not part
of the sql standard at all, and calling a separate function
after the insertion takes place just happens to be
mysql's way of doing it.

Anon

You can do it "in mysql" like this...

$result = mysql_query("INSERT INTO your_table VALUES ('$your_text')");
$result = mysql_query("INSERT INTO second_table VALUES (LAST_INSERT_ID(),'$your_info','$more_info')");

$num = mysql_insert_id($link_id) will return that number to PHP if you need it.

---John Holmes...