title: MySQL Insert Into from one Database in another
body: <p>I need to migrate data from one Database to another one, both are on the same local system.</p>
  
  <p>The tables and columns got different names and I mustn't migrate all the Columns from the old Database, so </p>
  
  <p><code>Select *</code> doesn't work for me.</p>
  
  <pre><code>INSERT INTO newDatabase.table1(Column1, Column2);
  SELECT oldDatabase.table1(column1, column2) FROM oldDatabase.table1
  </code></pre>
  
  <p>but all i got is a <code>#1064 - Syntax Error</code></p>
  
  <p>What is the error in my Query and How can i fix this ?</p>
  
  <p>Thanks in advance</p>