title: Efficient Insert Query Against Multiple Tables in MySQL
body: <p>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:</p>
  
  <pre><code>INSERT INTO table1 
    (t1c1, t1c2, t1c3), table2 (t2c1, t2c2, t2c3) 
  VALUES
    ('t1c1', 't1c2', 't1c3', 't2c1', 't2c2', 't2c3');
  </code></pre>
  
  <p>The reason for this is that the data is collated on a remote machine and will be doing the insert over the network.</p>