Efficient Insert Query Against Multiple Tables in MySQL

Question

I was wondering if there is a more efficient way of doing an insert in MySQL against multiple tables than a separate insert query for each record in each table. I was thinking of doing something like this:

INSERT INTO table1 
  (t1c1, t1c2, t1c3), table2 (t2c1, t2c2, t2c3) 
VALUES
  ('t1c1', 't1c2', 't1c3', 't2c1', 't2c2', 't2c3');

The reason for this is that the data is collated on a remote machine and will be doing the insert over the network.

Answer 1

You could insert into one table first, then into the second one from the first table:

INSERT INTO table1 ....
VALUES(....

INSERT INTO table2(....
SELECT ...
FROM table1 
WHERE ....

Answer 2

No, there is no way of doing this in a single step. You will need to perform multiple queries.