title: Copy row but with new id
body: <p>I have a table "test" with an auto incremented <code>id</code> and an arbitrary number of columns.</p>
  
  <p>I want to make a copy of a row in this table with all columns the same except for the <code>id</code> of course. </p>
  
  <p>Is there a way to do this without naming all columns? </p>
  
  <p>I thought <code>INSERT... SELECT... ON DUPLICATE KEY</code> would help me until I realised that it never makes an <code>INSERT ON DUPLICATE</code>, it just updates the existing row.</p>