Answers for "how can you delete duplicate records in a table with no primary key?"

mysql delete duplicate rows but keep one

DELETE c1 FROM contacts c1
INNER JOIN contacts c2 
WHERE
    c1.id > c2.id AND 
    c1.email = c2.email;

Posted by: Guest on February-04-2021

Code answers related to "how can you delete duplicate records in a table with no primary key?"