delete from case_records where id not in (select id from (select min(id) as id from case_records where if_out=0 group by user_id) as b);
mysql根据条件删除重复的数据保留一条
最新推荐文章于 2024-07-11 10:27:20 发布
delete from case_records where id not in (select id from (select min(id) as id from case_records where if_out=0 group by user_id) as b);