How to get the last inserted row ID in MySQL

Question

I want to get the last inserted ID when i insert the new data into the database help me with msql query

dharmendr · Accepted Answer

Hi  kishore21If your ID is AutoIncrement Column call LASTINSERTID function immediately after insertionSELECT LASTINSERTID

dharmendr · Answer

While inserting the record are you inserting the ID serially or randomlyIf you are inserting serially then use MAX functionSELECT MAXID FROM TableName

How to get the last inserted row ID in MySQL

Company

Explore

Follow us

Contact Us