returning the results of the previous insert

[carpeliam]

say I run the following insert:

insert into TableName (col1, col2) values (val1, val2);

this is on a table with an AUTO_INCREMENT id field. I want to know the value of ID after I run the insert.

[ol][li]Am I correct in assuming that the only way to do this is to select the row from TableName that has the largest value for id?[/li]
[li]is that method completely reliable?[/li]
[/ol] Liam Morley
lmorley@wpi.edu
"light the deep, and bring silence to the world.
light the world, and bring depth to the silence."

 

[cDevX99]

Nope, real easy....use this function immediately after doing the insert, it will return the last value that was alotted in the auto increment column...

int mysql_insert_id (resource [link_identifier])

You can read the details here...

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

 

[carpeliam]

I'm confused - is that a PHP function, or a MySQL function? I'm using Java (JDBC)... <p>Liam Morley<br><A HREF="mailto:"></A><br>&quot;light the deep, and bring silence to the world.<br>light the world, and bring depth to the silence.&quot;

 

[Broccoli2]

The php function is

mysql_insert_id()

.
The MySQL function is

LAST_INSERT_ID()

.
See

http://www.mysql.com/doc/G/e/Getting_unique_ID.html

for more info.

-Rob

 

[carpeliam]

Outstanding, it works. Thanks ) <p>Liam Morley<br><A HREF="mailto:"></A><br>&quot;light the deep, and bring silence to the world.<br>light the world, and bring depth to the silence.&quot;