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);
转载请注明:REB站长网 » 删除重复数据,保留最小ID的
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);
转载请注明:REB站长网 » 删除重复数据,保留最小ID的