Mysql清除重复记录 DELETE FROM hd_eventmonitor where id not in (select bid from(select min(id) as bid from hd_eventmonitor group byhdsas_id,leverid,eventnum,dt) as b ); 待续 来自东子的博客