Discussion board
How to find out which auto increment was assigned on the last insert?
By Abhijit Paul
Hi sir,

find previous auto increment....
Reply
Post   Reset
Teacher SiliconIndia replied to Abhijit Paul Monday, November 23, 2009
Hi Abhijit,

It can be done as follows:

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

Hope you got your query cleared.