日期:2014-05-16  浏览次数:20713 次

MYSQL删除重复记录的特殊方法
DELETE test AS a FROM test AS a,(SELECT *, min(id) FROM test GROUP BY NAME HAVING count(1)> 1)AS b WHERE a. NAME = b. NAME AND a.id > b.id;