title: Adding an extra column value with INSERT ... SELECT in MySQL
body: <p>I have two tables and my goal is to move specific data from the first table into the second table along with a reason for why that data was moved. For instance:</p>
  
  <pre><code>raw_data_table
  
  SELECT * FROM raw_data_table where id IS NULL;
  </code></pre>
  
  <p>I would want to move this into the second table, which is identical to the first table except for an extra column <code>reason</code>. I tried:</p>
  
  <pre><code>INSERT INTO bad_data_table 
  (SELECT * FROM raw_data_table WHERE id IS NULL), "The ID is NULL";
  </code></pre>
  
  <p>But this returns a syntax error. How can I copy the entire row over and add the reason value?</p>