Home > DeveloperSection > Interviews > How do you find out which auto increment was assigned on the last insert?

Posted on    April-09-2012 9:10 AM

 1 Answer(s)
  1892  View(s)
Rate this:

Arun Singh

Total Post:310

Posted on    April-09-2012 12:00 AM

SELECT LAST_INSERT_ID() will return the last value assigned by the auto_increment function. Note that you don’t have to specify the table name.

Don't want to miss updates? Please click the below button!

Follow MindStick