title: Issue with copying from one MySQL table to another
body: <p>I'm trying to copy from one table to another table and it works fine, however I also need to insert the current user ID in the new table. I haven't yet figured out how. Normally I would do something like <code>SET user_id = :user_id</code>, but i have never worked with this one.</p>
  
  <p>This is my code:</p>
  
  <pre><code>$q = $conn-&gt;prepare("INSERT INTO user_themes(title,code_entry,code_home,code_css,code_category,code_archive)
      SELECT title, code_entry, code_home, code_css, code_category, code_archive FROM blogy_themes WHERE id = :id");
  </code></pre>
  
  <p><strong>So my question is:</strong> 
  How can I insert <code>user_id</code> (let's say user_id is 1) into the new table as well?</p>