mysql查找表内字段重复的数据
查找重复:
SELECT itemid,wikiid,title from km_article_23 WHERE wikiid IN( select wikiid from km_article_23 GROUP BY wikiid HAVING COUNT(wikiid)>1 )
删除数据并保留ID为最小一条为唯一数据
正确SQL写法: DELETE FROM brand WHERE brandName IN (SELECT brandName FROM (SELECT brandName FROM brand GROUP BY brandName HAVING COUNT(brandName)>1) e) AND Id NOT IN (SELECT Id FROM (SELECT MIN(Id) AS Id FROM brand GROUP BY brandName HAVING COUNT(brandName)>1) t) #查询显示重复的数据都是显示最前面的几条,因此不需要查询是否最小值