MYSQL Record Clone

How to Clone MYSQL Record ?


4 Steps to Create MYSQL CLONE

1) Create Temporary table (`tbl_modulesss`) and copy from original table (`tbl_modules`) 

2) Update ID in Temporary Table (`tbl_modulesss`) 

3) Insert Temporary table data in to Original table

4) Drop temporary table

Done So Simple


CREATE TEMPORARY TABLE `tbl_modulesss` SELECT * FROM `tbl_modules` WHERE id =11;
UPDATE `tbl_modulesss` SET id =25;
INSERT INTO `tbl_modules` SELECT * FROM `tbl_modulesss`;
DROP TABLE `tbl_modulesss`;