/SQL/Identify rows with 2 same column value and delete duplicate mysql

Identify rows with 2 same column value and delete duplicate mysql

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: mysqltutorial.org

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)

Source: mysqltutorial.org

Similar codes

0 vote189 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
16 votes144 views2 answers
Mysql date between two dates
SQL
0 vote169 views2 answers
Uninstall postgresql mac
SQL
1 vote150 views5 answers
Postgresql difference between two dates in days
SQL
0 vote154 views1 answer
Mysql listing get a particu particular user firsdt
SQL
24 votes146 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
0 vote135 views2 answers
Mysql disable foreign key checks
SQL
0 vote152 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
0 vote176 views1 answer
Calculer pourcentage mysql
SQL
10 votes100 views1 answer
Oracle view dependencies
SQL