你的位置：REB站长网 > MYSQL > 删除重复数据，保留最小ID的

删除重复数据，保留最小ID的

MYSQL reebor 7个月前 (11-10) 267浏览 0评论

delete from maccms.`maccms_vod` where d_id not in (select minid from (select min(d_id) as minid from maccms.`maccms_vod` group by d_name) b);