mysql中有一个表将近六百万数据有两个重复的,如何可以高效的把这两个重复的找出来并删除啊?
2条回答 默认 最新
- ll89308839 2012-03-28 19:27关注
[code="java"]
select rowname from tableName group by rowname
having count(rowname ) > 1
[/code]本回答被题主选为最佳回答 , 对您是否有帮助呢?解决评论 打赏 举报无用 1
[code="java"]
select rowname from tableName group by rowname
having count(rowname ) > 1
[/code]