title: INSERT INTO SELECT + 1 custom column
body: <p>I need to copy data from original table and add custom column specified in query</p>
  
  <p>Original table struct: <code>col1, col2, col3</code></p>
  
  <p>Insert table struct: <code>x, col1, col2, col3</code></p>
  
  <pre><code>INSERT INTO newtable 
     SELECT * 
     FROM original 
     WHERE cond
  </code></pre>
  
  <p>and I'm getting this error</p>
  
  <blockquote>
    <p><em>Column count doesn't match value count at row 1</em></p>
  </blockquote>
  
  <p>HOW can I insert <code>X</code> value in this single query?</p>
  
  <p>I tought something like this can pass</p>
  
  <pre><code>INSERT INTO newtable 
     SELECT 'x' = NULL, *  
     FROM original 
     WHERE cond
  </code></pre>
  
  <p>Any ideas?</p>
  
  <p>Is it possible to use <code>*</code>? Because that table has so many columns and <code>X</code> has to be first value</p>
  
  <p>I know this all is bad but I have to edit unbeliveable ugly db with even worse php code</p>