先查询重复记录值
select * from tbname where uid in (select uid from tbname group by uid having count(uid)>1);
能查询,应该就能删除
delete from tbname where uid in (select uid from tbname group by uid having count(uid)>1);
但是报错:You can't specify target table,意思是目标表不明确
修改sql语句,将查询结果放入一个临时表
delete from tbname where uid in (
select tmptb.uid(
select uid from tbname group by uid having count(uid)>1
) as tmptb
);
本文章为转载内容，我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题，欢迎原作者联系我们进行内容更正或删除文章。
