How To Delete Duplicate Rows From The Database Table?

1
2
3
4
5

DELETE t1 
FROM table_name t1 
INNER JOIN table_name t2 
WHERE 
t1.id < t2.id AND t1.column_name = t2.column_name

1
2
3
4
5

DELETE t1 
FROM user t1 
INNER JOIN user t2 
WHERE 
t1.id < t2.id AND t1.email= t2.email