Answers for "identify rows with 2 same column value and delete duplicate mysql"

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
0

identify rows with 2 same column value and delete duplicate mysql

DELETE c1 FROM contacts c1
INNER JOIN contacts c2 
WHERE
    c1.id > c2.id AND 
    c1.email = c2.email;
Code language: SQL (Structured Query Language) (sql)
Posted by: Guest on December-27-2021

Code answers related to "identify rows with 2 same column value and delete duplicate mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language