title: Insert Into Statement - Omitting one Column
body: <p>I am trying to insert into a table all data but change just the date column</p>
  
  <p>So far I have something like </p>
  
  <pre><code>INSERT INTO MyTable (SELECT * FROM MyTable...)
  </code></pre>
  
  <p>What I want to do is set one of the columns to be a constant value (like todays date instead of what is selected out)</p>
  
  <p>Does anyone know of an easy way of doing that</p>