title: MySQL: Select row by id, CHANGE id, and insert it into another table
body: <p>I have two tables, A and B. </p>
  
  <p>I'd like to select a row from B based on it's Primary Key, alter the primary key to a different value, and then insert this row into A. </p>
  
  <p>Something like this: </p>
  
  <pre><code>INSERT INTO A SELECT id, title, date FROM B WHERE B.id="4" UPDATE B SET id="5";
  </code></pre>
  
  <p>Is there a solution for this? </p>