mysql 删除数据重复的记录

delete from user where id not in ( select * from ( select min(id) from user group by username,email ) ) as tmp;

转载于:https://www.cnblogs.com/xielisen/p/6791772.html