MySQL gets the data just inserted

1. Obtained by the self-increment key auto_increment.

Select Max (ID) from TableName

This approach requires consideration of concurrency and the need to "X-lock" the primary table in a transaction, and then unlock it after the value of Max (ID) is obtained.

2. Using the Select LAST_INSERT_ID () method is a thread-safe operation. When using select last_insert_id (), be aware that when multiple records are inserted at one time, only the ID value of the first insert is obtained. " automatically returns the value of the first table set by the Auto_increment column in the last insert or UPDATE query "

MySQL gets the data just inserted