title: How to insert a row into one table in sql that is exact same as another table but only one column different?
body: <p>I have a table and I want to insert a new row that is exactly the same as one row EXCEPT with one column value different.</p>
  <pre><code>col1 col2 col3
  joe  ben  sam
  </code></pre>
  <p>My desired output for the new row being added would be</p>
  <pre><code>col1 col2 col3
  bob  ben  sam
  joe  ben  sam
  </code></pre>
  <p>As you can see the original column is still there but we added a new row with the first value being changed from joe to bob.</p>
  <p>Any ideas on the most elegant way to do this maybe without hard coding?  I was thinking maybe an insert based on a select * where condition but not sure. Any tips would be greatly appreciated. Thank you!</p>