title: INSERT with SELECT
body: <p>I have a query that inserts using a <code>SELECT</code> statement:</p>
  <pre><code>INSERT INTO courses (name, location, gid) 
  SELECT name, location, gid 
  FROM courses 
  WHERE cid = $cid
  </code></pre>
  <p>Is it possible to only select &quot;name, location&quot; for the insert, and set <code>gid</code> to something else in the query?</p>