Retrieving Auto-Incremented Value: MySQL Equivalent of SCOPE_IDENTITY
In SQL Server, the SCOPE_IDENTITY() function retrieves the last auto-incremented value generated by an INSERT statement. MySQL provides a similar function called LAST_INSERT_ID() to achieve this functionality.
MySQL LAST_INSERT_ID() Function
The LAST_INSERT_ID() function returns the last auto-incremented value generated for the current session, regardless of the table or database where it occurred.
Usage:
SELECT LAST_INSERT_ID();
This returns a single integer representing the last auto-incremented value.
Example:
INSERT INTO Table1 (Name) VALUES ('John'); SELECT LAST_INSERT_ID();
This would return the auto-incremented ID assigned to the newly inserted row in Table1.
Note:
LAST_INSERT_ID() operates on a session-specific basis. This means that if you have multiple database connections, each session will retrieve its own last auto-incremented value.
In Case of Triggers:
LAST_INSERT_ID() retrieves the value of the last inserted row in the current table, even if it was inserted as a result of a trigger.
The above is the detailed content of How to Retrieve the Last Auto-Incremented ID in MySQL?. For more information, please follow other related articles on the PHP Chinese website!