title: How to use SELECT INTO with static values included?
body: <p>I'd like to add a value to the values provided by a SELECT INTO statement.</p>
  
  <p>Given the table named foo:</p>
  
  <pre><code>+----+
  | id |
  +----+
  | 1  |
  | 2  |
  | 3  |
  +----+
  </code></pre>
  
  <p>I would like to populate the table bar with:</p>
  
  <pre><code>+----+------+
  | id | type |
  +----+------+
  | 1  | R    |
  | 2  | R    |
  | 3  | R    |
  +----+------+
  </code></pre>
  
  <p>I'd imagine this looking something like this:</p>
  
  <pre><code>SELECT foo.id, type INTO bar FROM foo LEFT JOIN 'R' AS type;
  </code></pre>
  
  <p>... unfortunately this doesn't work. Can anyone tell me how to do this please</p>
  
  <p>I'm using both mysql and mssql</p>