做个笔记
DELETE FROM tablename where id not in (select id from (select min(id) as id from tablename group by key) as b ) ;
其中key是重复的字段
做个笔记
DELETE FROM tablename where id not in (select id from (select min(id) as id from tablename group by key) as b ) ;
其中key是重复的字段