Get the AutoNumber ID of a row just INSERTed with MySQL

Question

I am using an INSERT to create a new record in my database which is identified by an autonumber field "product_id". Immediately after I insert the row, I need to get the ID of the new row so I can output the info for further processing. Is there any mysql function to get this ID?

This is generally carried out via a scripting language - are you using one? (If not simply use SELECT LAST_INSERT_ID();. If however you're using a scripting language you need to use the language specific means if there is one.) — John Parker
– John Parker, Commented Feb 8, 2011 at 21:02
possible duplicate of [Select last insert id ](stackoverflow.com/questions/2266604/select-last-insert-id) — John Parker
– John Parker, Commented Feb 8, 2011 at 21:23

Jith · Accepted Answer · 2011-02-08 21:06:08Z

3

LAST_INSERT_ID() returns automatically generated AUTO_INCREMENT value.

answered Feb 8, 2011 at 21:06

Jith

1,7013 gold badges16 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

HBlend · Accepted Answer · 2011-02-08 21:02:03Z

0

See: http://dev.mysql.com/doc/refman/5.0/en/getting-unique-id.html

Note: this is assuming the c api.

From the text:

20.8.10.3. How to Get the Unique ID for the Last Inserted Row

If you insert a record into a table that contains an AUTO_INCREMENT column, you can obtain the value stored into that column by calling the mysql_insert_id() function.

answered Feb 8, 2011 at 21:02

HBlend

5651 gold badge3 silver badges13 bronze badges

6 Comments

MarathonStudios Over a year ago

This will work perfectly for this app, but just out of curiosity, will this be safe to use in large applications with many concurrent selects being streamed in?

John Parker Over a year ago

@MarathonStudios Are you accessing MySQL via a scripting language such as PHP? If so, this isn't the correct approach to use.

HBlend Over a year ago

@MarathonStudios: Assuming threaded C, if each thread has its own connection to the db, you should be safe. From the docs: "The value of mysql_insert_id() is affected only by statements issued within the current client connection. It is not affected by statements issued by other clients."

John Parker Over a year ago

@MarathonStudios PHP does indeed have a dedicated mysql_insert_id function that's thankfully named the same thing as the C API function @HBlend mentions. Incidentally, if you'd tagged this question as PHP you'd have had a more relevant/accurate answer earlier.

Teson Over a year ago

So what's the final conclusion here, is mysql_insert_id thead-safe (under php5.3)?

|

Collectives™ on Stack Overflow

Get the AutoNumber ID of a row just INSERTed with MySQL

2 Answers 2

Comments

6 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

6 Comments

Related