WyseLabs Internet Marketing Forum :: Start Sharing

We can duplicate records in our MySQL table using SELECT COUNT(*) FROM YOUR_TABLE;

INSERT INTO YOUR_TABLE
SELECT *
FROM YOUR_TABLE
WHERE COUNT =(SELECT COUNT(*)
FROM YOUR_TABLE);

Duplicate record is only possible if your table has no primary key as primary key will not allow duplicates otherwise its ok to duplicate record.

This type of SQL statement is helpful when we are fetching entire row from one table and inserting to another for ex:-in e-commerce projects. Need to make sure that the fields in both table are same.