MySQL Duplicate Function

Sometimes you want the ability to duplicate (clone) entities in mySQL. But duplicating their children can be a huge pain! Here’s how:

important note! make sure that you don’t select the primary key of the table. instead, select 0, and the auto_increment function will automatically figure out the correct primary key.

/* parent table */

insert into [parent table]
select 0, [field1, field2, field3]
from [tablename]
where [parent table primary key] = [parent table object ID]

/* child table */

insert into [child table]
select 0, [field1, field2, field3],
(select max([parent table primary key]) from [parent table]) from [child table]
where [parent table primary key] = [parent table object ID]