title: MySQL export query as insert statements
body: <p>I have two mysql tables which both have a typeID in common.  I am wanting to select everything from these two tables with the same typeID, query below:</p>
  
  <pre><code>SELECT ta.requiredTypeID, ta.typeID, ta.quantity 
    FROM `invtypes` as t, `typeactivitymaterials` as ta 
    WHERE volume &gt; 0 AND t.typeID = ta.typeID;
  </code></pre>
  
  <p>This gives me the correct results but I am trying to export this query as insert statements.  I have tried adding INTO OUTFILE "/path/" but this only exports the data as tab/comma delimited data, is it possible to export this data as insert statements?</p>
  
  <p>Cheers</p>
  
  <p>Eef</p>