DELETE t2 from table AS t1, table AS t2 WHERE t1.field = t2.field AND t2.id < t1.id
Thursday, October 16, 2008
Find and delete duplicate records in MYSQL
Subscribe to:
Post Comments (Atom)
DELETE t2 from table AS t1, table AS t2 WHERE t1.field = t2.field AND t2.id < t1.id
No comments:
Post a Comment