How to copy a row and insert in same table with a autoincrement field in MySQL?
Use INSERT … SELECT: insert into your_table (c1, c2, …) select c1, c2, … from your_table where id = 1 where c1, c2, … are all the columns except id. If you want to explicitly insert with an id of 2 then include that in your INSERT column list and your SELECT: insert into your_table … Read more