Re: How do you insert into two tables at once

David wrote: > I have two tables under the one database. What is the best way to > INSERT data into both tables at once. Can I use one INSERT statement or > do I have to use two? Do those tables have exactly same tructure? If you then you do not have to insert into two table but use MERGE t

Re: How do you insert into two tables at once

"David" <[EMAIL PROTECTED]> wrote: > I have two tables under the one database. What is the best way to > INSERT data into both tables at once. Can I use one INSERT statement or > do I have to use two? Two inserts are required. You can insert multiple rows into a table via a single insert, but

How do you insert into two tables at once

I have two tables under the one database. What is the best way to INSERT data into both tables at once. Can I use one INSERT statement or do I have to use two? - Before posting, please check: http://www.mysql.com/manual.php