Monthly Archives: September 2014

Quickly duplicate a row in MySQL

A quick way of duplicating a row in a table without running into duplicate key errors or having to type out all the field names… Not quite a one-liner, but very straightforward. /* Duplicate row 58 from mytable */ CREATE TEMPORARY TABLE tmptable SELECT * FROM mytable WHERE id = 58;   /* Change the… Read more »