Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How can we find out which auto increment was assigned on Last insert?

user-image
Question added by Julfkar Moh Umar , Sr. Software Engineer , Aakash Edutech Private Limited
Date Posted: 2016/01/14
Jargam Abbas Sayyed Mohammad Azam
by Jargam Abbas Sayyed Mohammad Azam , Senior Software Developer , Trimax Infrastructure Ltd.

Use LAST_INSERT_ID() from your SQL query or you can also use mysql_insert_id() to get it using PHP.

 

LAST_INSERT_ID() can be used to fetch latest auto increment id being used in any INSERT query that was just got executed.

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.