title: copy data from another table which doesn't exist in the first one.
body: <p>How can we copy data from one table into another table which doesn't exist in the first one.  In table one of the column is primary key. </p>
  
  <pre><code>INSERT INTO table SELECT * FROM db2.table; 
  ERROR 1062 (23000): Duplicate entry '100001' for key 'id_UNIQUE'
  </code></pre>