akosch
Reputation: 4396
How can i get the value of a pkey for a record just inserted (autoincrement)?
I'm subsequently inserting a single record in two tables. With the first insert i put the record in the main table, where the primary key value gets generated. Now i need to put some fields of this record in another table including the key value of the main table. How do i do this?
Upvotes: 4
Views: 156
Answers (1)
Jorge Villuendas Zapatero
Reputation: 2330
"SELECT LAST_INSERT_ID();" will return the last autoincrement ID generated.
Upvotes: 3
Related Questions
- Get the new record primary key ID from MySQL insert query?
- Retrieve Auto Increment ID from SQL Database after Insert Statement
- getting the autoincremnt value after inserting record using SQL Server
- How to Get Next Auto Increment ID Before Inserting MYSQL
- C# Get insert id with Auto Increment
- Can one obtain the value being inserted with an auto increment pk?
- Get Autoincrement value after INSERT query in MySQL
- Get the value of an auto increment PK column
- Get autoincrement id after an insert query performed
- Catch Id (INT AUTO INCREMENT) of a Record after INSERT INTO Statement