How do I get the last inserted row ID?

How do I get the last inserted row ID in SQL?

To get an ID of last inserted record, you can use this T-SQL: INSERT INTO Persons (FirstName) VALUES ('Joe'); SELECT ID AS LastID FROM Persons WHERE ID = @@Identity; You can use query like this inside stored procedure or as an ad-hoc query.

How do I get last insert ID?

9 Obtaining the Unique ID for the Last Inserted Row. If you insert a record into a table that contains an AUTO_INCREMENT column, you can obtain the value stored into that column by calling the mysql_insert_id() function.

How do you get the ID of the inserted row in SQL?

4 ways to get identity IDs of inserted rows in SQL Server1INSERT INTO TableA (...) VALUES (...) SET @LASTID = @@IDENTITY.2INSERT INTO TableA (...) VALUES (...) SET @LASTID = SCOPE_IDENTITY()3SET @LASTID = IDENT_CURRENT('dbo.TableA')4DECLARE @NewIds TABLE(ID INT, ...) INSERT INTO TableA (...) OUTPUT Inserted.ID, ...4 ways to get identity IDs of inserted rows in SQL Server

How can I get last insert ID in PDO?

You can use PDO::lastInsertId() . @ArtGeigel It will be the last inserted ID of the connection underlying the PDO instance.