CODEWITHSUNDEEP
mysql
diya
diya

Reputation: 7138

How to use last_insert_id() in MySQL?

My SQL statements like this:

INSERT INTO foo (val1) VALUES('v1');      -- ID in first table
foo_id = SELECT last_insert_id();

INSERT INTO bar (val2) VALUES ('v2');     -- ID in second table
bar_id = SELECT last_insert_id();

INSERT INTO foobar (foo_id, bar_id, val3)
VALUES (foo_id, bar_id, 'text');          -- third table

The above is not working, it doesn't recognize the foo_id = statement.

Upvotes: 1

Views: 10169

Answers (1)

scragar
scragar

Reputation: 6824

INSERT INTO foo (val1) VALUES ('v1');     -- ID in first table
SET @foo_id = last_insert_id();

INSERT INTO bar (val2) VALUES ('v2');     -- ID in second table
SET @bar_id = last_insert_id();

INSERT INTO foobar (foo_id, bar_id, val3)
VALUES (@foo_id, @bar_id, 'text');        -- third table

Upvotes: 6

Related Questions