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 , Sr. Technical Specialist , Samco Securities Limited

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