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