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

 MYSQL MYSQL 
Ratings:
 1 Answer(s)
  1652  View(s)
Rate this:

Arun Singh

Total Post:310

Points:1550
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