mysql get duplicate values code example
Example 1: find duplicates mysql column
SELECT name, COUNT(*) c FROM table GROUP BY name HAVING c > 1;
Example 2: mysql get latest duplicate rows
SELECT
t1.primary_id,
t1.duplicate_id,
t1.data1,
t1.data2
FROM
table_name t1
LEFT JOIN table_name t2
ON (t1.duplicate_id = t2.duplicate_id AND t1.primary_id < t2.primary_id)
WHERE
t2.primary_id IS NULL
Example 3: duplicate row mysql
INSERT INTO table (col1, col2, col3)
SELECT col1, col2, col3 FROM table
WHERE something...;