title: INSERT SELECT vs BATCH INSERT
body: <p>I have a question, does MySQL re-construct the query:</p>
  
  <pre><code>INSERT INTO table SELECT column1, column2 FROM table1
  </code></pre>
  
  <p>Into a batch insert:</p>
  
  <pre><code>INSERT INTO table VALUE (1,2),(3,4)
  </code></pre>
  
  <p>?</p>
  
  <p>Because I noticed that inserting with BATCH INSERT is much faster than INSERT SELECT.</p>