mysql delete duplicate rows
Monday, November 5th, 2007 Posted in MYSQL | 2 Comments »DELETE tablename FROM tablename, (SELECT MAX(uid) AS dupid,COUNT(uid) AS dupcnt FROM tablename GROUP BY id,url HAVING dupcnt>1) AS dups WHERE tablename.uid=dups.dupid;