title: INSERT INTO ... SELECT without detailing all columns
body: <p>How do you insert selected rows from <code>table_source</code> to <code>table_target</code> using SQL in MySQL where:</p>
  
  <ul>
  <li>Both tables have the same schema</li>
  <li>All columns should transfer except for the auto-increment <code>id</code></li>
  <li>Without explicitly writing all the column names, as that would be tedious</li>
  </ul>
  
  <p>The trivial <code>INSERT INTO table_target SELECT * FROM table_source</code> fails on duplicate entries for primary key.</p>