okami
Reputation: 2153
Get autoincrement id after an insert query performed
I want to get the autoincrement id of an insert.
is there a way to do it?
Upvotes: 1
Views: 1319
Answers (1)
Pekka
Reputation: 449823
Seeing as you're specifying only mySQL in your tags:
Use LAST_INSERT_ID(). Make sure to read the manual page for the subtleties.
The language you are querying mySQL from may have built-in API functions that do the same thing.
Upvotes: 7
Related Questions
- SQL, how to get the automated ID from the previous INSERT?
- Retrieving an autoincrement value after INSERT duplicate key
- Getting auto increment id with insert_id
- Get auto increment ID after insert to use on another insert
- MYSQL get auto increment/mysql_insert_id() at INSERT
- How to get currently inserted AUTO_INCREMENT id?
- Get autoincrement id after an insert query performed with a prepared statement
- MySQL: Get AUTO_INCREAMENTED sequence number after Insert?
- Mysql - Get auto increment id on actual insert
- How to get the id of an inserted row ON insert?