艺言弈行

摘要： 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 就可以了。 保留一条重复记录：... 阅读全文