This seems like a simple task:
insert into prizes select * from prizes where prize_id=16;
but it gives an error because the prize_id column is autoincrement.
this fails as well
insert into prizes select * from prizes where prize_id=16 ON DUPLICATE
KEY UPDATE prize_id=(select MAX(prize_id)+1 from prizes);
strangely changing the prize_id from 16 to 17 rather than inserting
I can create a temporary table with a single row, alter the prize_id
column in that table and insert the row back. I have also seen
solutions where the autoincrement is disabled and reenabled using
'modify table' commands, but that ...