The MySQL LAST_INSERT_ID() function returns the most recently generated integer successfully inserted for an
CREATE TABLE user( id INT AUTO_INCREMENT, name VARCHAR(250) NOT NULL ..., PRIMARY KEY(id) );
If you insert multiple rows into the table using a single
INSERT statement, the
LAST_INSERT_ID() function returns the first automatically generated value only.
If the insertion fails, the result returned by the
LAST_INSERT_ID() remain unchanged.
LAST_INSERT_ID() function works based on client-independent(database connection) principle. It means the value returned by the
LAST_INSERT_ID() function for a specific client is the value generated by that client only to ensure that each client can obtain its own unique ID. This means that each database connection will have its own LAST_INSERT_ID().
INSERT INTO user(name) VALUES('Folau');
The result is 1 which is the first id in the table.