title: mySql copy rows into same table with key value changed (not overwriting existing)
body: <p>How do I copy a selection of rows from a mySql table and insert with just the key value changed. Can I do a select and insert in same query?</p>
  
  <p>To be precise, what I want would look like this:</p>
  
  <p>Table cols, ID and ISO3 are keys:   </p>
  
  <pre><code>+----+------+-------------------------+
  | ID | ISO3 |          Text           |
  +----+------+-------------------------+
  |  1 | ENU  | A text in english       |
  |  2 | ENU  | Another text in english |
  |  3 | ENU  | bla bla                 |
  |  1 | JPN  | 与えられた枠             |
  +----+------+-------------------------+
  </code></pre>
  
  <p>After the insert I want my table to look like this:  </p>
  
  <pre><code>+----+------+---------------------------+
  | ID | ISO3 |           Text            |
  +----+------+---------------------------+
  |  1 | ENU  | A text in english         |
  |  2 | ENU  | Another text in english   |
  |  3 | ENU  | bla bla                   |
  |  1 | JPN  | 与えられた枠               |
  |  2 | JPN  | Another text in english   |
  |  3 | JPN  | bla bla                   |
  +----+------+---------------------------+
  </code></pre>