Tags
MySQL
Asked 2 years ago
30 May 2022
Views 405
jagdish

jagdish posted

how to use LAST_INSERT_ID() in MySQL

how to use LAST_INSERT_ID() in MySQL ?
jabber

jabber
answered May 31 '22 00:00

LAST_INSERT_ID() is MySQL function which return last insert id ,
example :


insert into products set name='Titan watch';
select LAST_INSERT_ID()


so in the above query, after inserting the product at the products table, the next query return the last inserted id in the products tables, products should id with auto-increment value.
Edit Answer
Post Answer
OMG!   You need to Login / Register to Post Answer
[code] Bold LE LP LD LW LDR WAR INF DAN SUC FYI h2 h3 italic