title: Add row that is duplicate except for one column
body: <p>I need to write a query to add a duplicate row to a table a bit like this... </p>
  
  <pre><code>INSERT INTO `&lt;table&gt;` (column1, column2, ...) -- Not IDENTITY columns
  SELECT column1, column2, ... FROM ...
  </code></pre>
  
  <p>except that the first column must have a different value in the copied row.</p>
  
  <p>i.e.</p>
  
  <pre><code>┌─────┬────────┬────────┐
  |name | weight | height |
  ├─────┼────────┼────────┤
  │ Bob │   100  │   150  │
  │     │        │        │
  └─────┴────────┴────────┘
  </code></pre>
  
  <p>To</p>
  
  <pre><code>┌─────┬────────┬────────┐
  |name | weight | height |
  ├─────┼────────┼────────┤
  │ Bob │   100  │   150  │
  │ Jim │   100  │   150  │
  └─────┴────────┴────────┘
  </code></pre>
  
  <p>I can't simply insert an identical row, and then update that column, because the "name" column is unique. </p>
  
  <p>Obviously in reality my table has many more columns than this example.</p>