title: How to copy 1 column from one db to another db and set constants for another column in the 1st db during the INSRT INTO statement?
body: <p>I have database1 with table table1 and 3 columns: column1a, column1b, column1c
  I have database2 with table table2 and 1 columns: column2a</p>
  
  <p>I would like to copy the values from the database2 (from column2a) to database1 column1a and the others values of column1b and column1c set to a certain constant value e.g.</p>
  
  <pre><code>INSERT INTO database1.table1 (column1a,'column1b' = 'apple','column1c'= 'orange') SELECT `column2a` FROM database2.table2;
  </code></pre>
  
  <p>However, in the fisrt part if the statemnt are 3 values and in the second is only 1, so I suppose there is a problem and this statement is bad :(.</p>
  
  <p>Any advice how to rewrite my mysql statement?</p>