title: INSERT INTO ... SELECT in mysql
body: <p>I have a big table(more than 60k rows), I am trying to copy unique rows from this table to another table. Query is as follows</p>
  
  <pre><code>INSERT INTO tbl2(field1, field2) 
  SELECT DISTINCT field1, field2 
     FROM tbl1;
  </code></pre>
  
  <p>But it is taking ages to run this query, can someone suggest any way to accelerate this process</p>