Multi-Row insert: refer to first AUTO_INCREMENT

[phant0m]

Hi

 

I have a parent/child structure and I'd like to be able to insert them all at once.

INSERT INTO table (parent_id, description) VALUES
(null, parent item), (<expression to refer to the auto_increment value of the previously inserted row>, child item)

LAST_INSERT_ID() always return the AUTO_INCREMENT from the last query, so I can't use that.

Is there any way to accomplish doing it in one query instead of inserting the parent item in a query, and all the children in a second query?

[Mchl]

There isn't.

[phant0m]

ok, thanks.