摘要:
1.查找重复记录:(按id查找)select * from user_info where id in ( select id from user_info group by id having count(id)>1 )即:select * from user_info where id in(select id from user_info group by id having count(id)>1)2.删除重复记录: 不保留重复记录,只需把上面的select * from 改成 delete from 就可以了。 保留一条重复记录:... 阅读全文