{"id":235423,"date":"2024-07-04T06:18:04","date_gmt":"2024-07-04T06:18:04","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/?p=235423"},"modified":"2024-07-04T06:18:04","modified_gmt":"2024-07-04T06:18:04","slug":"how-to-get-primary-key-value-after-insert-in-sql","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-get-primary-key-value-after-insert-in-sql\/","title":{"rendered":"How to get primary key value after insert in SQL?"},"content":{"rendered":"

When inserting a new record into a database table that has an auto-incrementing primary key, you may need to retrieve the value of the primary key that was generated for the inserted record. This primary key can be useful for further operations or for displaying to the user. Here’s how you can get the primary key value after an insert operation in SQL:<\/p>\n

**Use the LAST_INSERT_ID() function to retrieve the primary key value after an insert operation. This function returns the last automatically generated value that was set for an AUTO_INCREMENT column in the current session.**<\/p>\n

Here’s an example of how you can use the LAST_INSERT_ID() function after an insert operation:<\/p>\n

“`sql
\nINSERT INTO users (name, email) VALUES (‘John Doe’, ‘john.doe@example.com’);
\nSELECT LAST_INSERT_ID();
\n“`<\/p>\n

In this example, after inserting a new record into the “users” table, the SELECT statement will return the primary key value that was generated for the inserted record.<\/p>\n

\n
\n

Table of Contents<\/p>\nToggle<\/span><\/path><\/svg><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n