[RESOLVED] MySQL Query (Multi-Statement) Help

[big_nerd]

Hello All,

I am working on a project (osCommerce Mod), and I need to insert values into two tables, one into a configuration_group table, which has an auto-increment value, and many values into the configuration table USING the insert ID from the previous.

i.e.

insert into configuration_group, I need to get that ID, and use it in 15 or so following inserts into another table, which needs that insert ID to reference back.

I know how to do this in PHP w/ Multiple statements, but I am wondering if it is possible with one single query?

I hope this makes sense..

Thanks in advance for all the help..

[Piranha]

insert into table (column1, column2) values (value1, value2), (value3, value4);

[big_nerd]

Thanks, but that much I know, maybe I should elaborate...

I want to be able to get the insert id (or auto_increment value) from the first table...

i.e. insert blah into table_one

get THAT insert ID (auto_increment value) (as insert_id)

and insert blah_lbah into table_two (insert_id_from_above, etc,etc,etc)

I am thinking I should just use two queries in php, it may be easier...

[NogDog]

Or maybe write a stored procedure?

[Piranha]

If you don't use a stored procedure I think you have to first insert the common row, then get the id, then do one query as shown above to insert the 15 or so rows in another table.

[big_nerd]

Yeah, thanks everyone that's what I figured.

Excellent.