Answers for "remove duplicates mysql query"

SQL
1

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
4

mysql delete duplicates

DELETE FROM CONTACTS
WHERE ID NOT IN
      (SELECT *
       FROM (SELECT max(ID)		
             FROM CONTACTS
             GROUP BY EMAIL) t);
 -- ⇓ Test it ⇓ (Fiddle source link)
Posted by: Guest on July-13-2021

Code answers related to "remove duplicates mysql query"

Code answers related to "SQL"

Browse Popular Code Answers by Language