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

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!

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

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

Collectives™ on Stack Overflow

MySQL two LAST_INSERT_ID in one query

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related