how to get auto_increment field value

[Anon]

If I have an auto_increment field in my table and I add a row to that table w/ a PHP script, how do I figure out the value that was just issued to that auto_increment field?

[Anon]

This function return what u want.

mysql_insert_id ([int link_identifier])

but only for MYSQL.

[[deleted]]

Just a general note:

Functions like this are documented in the manual.

READ THE MANUAL before posting elementary questions like this.

[Anon]

mysql_insert_id ([int link_identifier])

is not reliable, esp with high concurrency. I use a sequence table, a bit like php_lib do

Nisan

Mike the edge wrote:

This function return what u want.

mysql_insert_id ([int link_identifier])

but only for MYSQL.

[[deleted]]

Uhm... mysql_insert_id() reads the content of the auto_increment (sequence) column in the table and returns the last value inserted through the connection that you are using.

[kparker]

This is the second time I've seen this alleged here, but nothing at all is mentioned about this problem on mysql.com. Is there any real evidence of this? Is mysql just covering up the bug? Or is it just urban legend?

[[deleted]]

Must be a legend because MySQL is still being used for high-concurrency applications and I've never heard anybody complain about not getting reliable results so far...