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

Question

Hello
How do you find out which auto increment was assigned on the last insert?
please reply me. i am waiting for your reply.
Thanx

Answer 1

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.