delete from table_name where id not in (select minid from (select min(id) as minid from table_name group by name) b);
Mysql去重,保留最小id的字段
最新推荐文章于 2024-04-27 10:32:35 发布
delete from table_name where id not in (select minid from (select min(id) as minid from table_name group by name) b);