select * from list
where username in (select username from list group by username having count(username) > 1)
where username in (select username from list group by username having count(username) > 1)
这样list表中用户名重复的就会显示出来了,然后执行:
delete from list
where username in (select username from list group by username having count(username) > 1)
查询完成,手工。问题解决了