title: merge tables in two databases
body: <p>I have at present two different databases, and i would like to copy or merge all columns from table A into table B. I am using the following commands</p>
  
  <pre><code>USE B;
  INSERT INTO B SELECT * FROM A.col1;
  INSERT INTO B SELECT * FROM A.col2;
  etc
  </code></pre>
  
  <p>What I would like to achieve is </p>
  
  <p>For example, database A contains tables (A_1, A_2); database B contains tables (B_1, B_2);
  and the newly created B should be (A_1, A_2, B_1, B_2)</p>
  
  <p>Thanks Gosh it doesn't work at all;</p>