Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

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;
Source by www.mysqltutorial.org #
 
PREVIOUS NEXT
Tagged: #mysql #delete #duplicate #rows
ADD COMMENT
Topic
Name
6+6 =