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

基于MySQL的如何查询重复数据方法
在项目中有一个数据表出现了重复的数据需要把它查询出来找一下是哪里出了问题:
SELECT flux.*
FROM flux,(
  SELECT web_address,web_ip
  FROM flux
  GROUP BY web_address,web_ip
  HAVING COUNT(1) > 1
) AS nick
WHERE flux.web_address = nick.web_address
  AND flux.web_ip=nick.web_ip