Remove Duplicate Records from MySQL Server

DELETE S1 FROM table_name AS S1  
INNER JOIN table_name AS S2   
WHERE S1.id > S2.id AND S1.email = S2.email;  
Amardeep Dubey
Latest posts by Amardeep Dubey (see all)
0 0 votes
Article Rating
Subscribe
Notify of
guest

0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x