title: How do I INSERT INTO from one mysql table into another table and set the value of one column?
body: <p>I need to insert data from table1 into table2. However, I would like to set the myYear column in table2 to 2010. But, there isn't a myYear Column in table1.</p>
  
  <p>So, my basic insert looks like:</p>
  
  <pre><code>INSERT INTO  `table2` ( place, event ) 
  SELECT place, event
  FROM table1
  </code></pre>
  
  <p>Roughly, I'd like to do something like the following:</p>
  
  <pre><code>INSERT INTO `table2` ( place, event, SET myYear='2010' )
  ...
  </code></pre>
  
  <p>Is there a way to set the column value in the insert statement?</p>