In MySQL, can I copy one row to insert into the same table? - Stack Overflow

I used Leonard Challis's technique with a few changes: CREATE TEMPORARY TABLE tmptable_1 SELECT * FROM table WHERE primarykey = 1; UPDATE tmptable_1 SET primarykey = NULL; INSERT INTO table SELECT * FROM tmptable_1; DROP ...

stackoverflow.com