title: SQL INSERT INTO with subquery and value
body: <p>Is there a way I can use a combination of hard values and a subquery to insert into a table with one command?</p>
  
  <p>For example: </p>
  
  <pre><code>INSERT INTO suppliers (supplier_id, supplier_name, supplier_type)
  SELECT account_no, name
  FROM customers
  WHERE city = 'San Diego';
  </code></pre>
  
  <p>I need supplier_type to be 3. So can I do the following for the second line?</p>
  
  <pre><code>SELECT account_no, name, supplier_type = 3
  </code></pre>
  
  <p><strong>supplier_type is not in the customers table</strong></p>