MySQL two LAST_INSERT_ID in one query

Question

I have 3 tables:

Words { wordId, name }
WordGroups { wordGroupId, type}
WordSets { wordSetId, wordId, wordGroupId}

I need to Insert new Word, and new WordGroup and after that insert WordSet with 2 new ids (wordId and WordGroupId).

I make this:

INSERT INTO `wordgroups`(`type`) VALUES ('some_type'); 
SET @gid:=LAST_INSERT_ID();
INSERT INTO `words`(`name`) VALUES ('test name');
SET @wid:=LAST_INSERT_ID();
INSERT INTO `wordsets`(`wordGroupId`,`wordId`) VALUES(@gid,@wid);

It works, but I have doubts that this is the best way.

Does anyone have advice about better solution?

the solution you have is the best solution possible.

Raymond Nijland
– Raymond Nijland

2018-02-27 14:04:00 +00:00
Commented Feb 27, 2018 at 14:04 — Raymond Nijland
– Raymond Nijland, Commented Feb 27, 2018 at 14:04
@RaymondNijland ok, thanks

Denis Ross
– Denis Ross

2018-02-27 14:05:51 +00:00
Commented Feb 27, 2018 at 14:05 — Denis Ross
– Denis Ross, Commented Feb 27, 2018 at 14:05

Jayson Sarino · Accepted Answer · 2018-02-27 14:07:22Z

1

In my opinion your code is good, I've tried that before and there is no conflict or bugs I encounter. That's the best practices.

Keep up the good work!

answered Feb 27, 2018 at 14:07

Jayson Sarino

11 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sagar Zond · Accepted Answer · 2018-02-27 14:31:29Z

1

Yes, this is the best possible solution. Just make sure this code in a transaction so that failure in anything will rollout others.

answered Feb 27, 2018 at 14:31

Sagar Zond

395 bronze badges

Collectives™ on Stack Overflow

MySQL two LAST_INSERT_ID in one query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related