MySQL inserting into multiple tables linked records

[monomaniac21]

Hi all

Using MySQL can anyone tell me how to most efficiently insert a collumn
in 'table1' retrieve the id from this record and insert mutliple
records into 'table2' with a collumn for the id in 'table1' which links
the two recordsets

[Marcin Dobrucki]

Re: MySQL inserting into multiple tables linked records

monomaniac21 wrote:[color=blue]
> Hi all
>
> Using MySQL can anyone tell me how to most efficiently insert a collumn
> in 'table1' retrieve the id from this record and insert mutliple
> records into 'table2' with a collumn for the id in 'table1' which links
> the two recordsets[/color]

set auto_commit=0
insert into foo values (...)
select last_insert_id( )
insert into bar values (....)
set auto_commit=1

[monomaniac21]

Re: MySQL inserting into multiple tables linked records

Thanks for the response Marcin but i still dont quite understand. could
you be any more elaborate please. Sorry.

Marcin Dobrucki wrote:[color=blue]
> monomaniac21 wrote:[color=green]
> > Hi all
> >
> > Using MySQL can anyone tell me how to most efficiently insert a collumn
> > in 'table1' retrieve the id from this record and insert mutliple
> > records into 'table2' with a collumn for the id in 'table1' which links
> > the two recordsets[/color]
>
> set auto_commit=0
> insert into foo values (...)
> select last_insert_id( )
> insert into bar values (....)
> set auto_commit=1[/color]