title: Adding rows from one table to another existing table where primary key is autogenerated
body: <p>I have two tables say Table1(<code>id</code>,<code>name</code>) and Table2 with (<code>id</code>,<code>name</code>).</p>
  
  <p>Table1 looks like:</p>
  
  <pre><code>id    name
   1     ABC
   2     DEF
  </code></pre>
  
  <p>Table2 looks like:</p>
  
  <pre><code>id    name
   1    XYZ
   2    ASD
  </code></pre>
  
  <p>Can someone shed light on how I can add Table2 rows to Table1 i.e.</p>
  
  <p>Table1 must finally look like:</p>
  
  <pre><code>id  name
   1   ABC
   2   DEF
   3   XYZ
   4   ASD
  </code></pre>