Forum : How do you find out which auto increment was assigned on the last insert?
Brief description  about Online courses   join in Online courses
View Arun  Desai 's Profile

How do you find out which auto increment was assigned on the last insert?

How do you find out which auto increment was assigned on the last insert????
Asked by Arun Desai | Mar 18, 2010 |  Reply now
Replies (1)
View teacher siliconindia 's Profile
Hi Arun,
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.
Mar 18, 2010