MySQL重复数据

delete from porn where Id not in (select minid from (select min(id) as minid from porn group by viewkey) b);

原文地址:https://www.cnblogs.com/zeze/p/5633517.html