title: How to copy a row and insert in same table with a autoincrement field in MySQL?
body: <p>In MySQL I am trying to copy a row with an <strong>autoincrement</strong> <code>column ID=1</code> and <strong>insert</strong> the data into same table as a new row with <code>column ID=2</code>.</p>
  
  <p>How can I do this in a single query?</p>