Get inserted row ids in PHP and MySQL with multiple inserts [duplicate]

Question

MySQL code is something like:

INSERT INTO table(name, value) VALUES ('name1', 'value1'), ('name2', 'value2'), ('name3', 'value3')

Basically, multiple inserts in the same SQL statement.

How can I get the IDs of the inserted values. I assume mysql_insert_id() combined with the number of inserts isn't safe since someone else might insert something at the same time.

Is there another way?

stackoverflow.com/questions/1285231/…

Vimalnath
– Vimalnath

2013-03-09 18:10:36 +00:00
Commented Mar 9, 2013 at 18:10 — Vimalnath
– Vimalnath, Commented Mar 9, 2013 at 18:10
Thanks vimalnath, didn't find that one.

cgf
– cgf

2013-03-09 18:15:52 +00:00
Commented Mar 9, 2013 at 18:15 — cgf
– cgf, Commented Mar 9, 2013 at 18:15

NovaDenizen · Accepted Answer · 2013-03-09 18:11:04Z

2

You either need to insert them one at a time or figure out the id's with a followup query.

INSERT INTO table(primkey, value) VALUES ('pk1', 'val1'), ('pk2', 'val2');
SELECT FROM table id, primkey where primkey in ('pk1', 'pk2');

answered Mar 9, 2013 at 18:11

NovaDenizen

5,39517 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

Get inserted row ids in PHP and MySQL with multiple inserts [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related