mysqlɾ³ý±íÖÐÔì³ÉΨһ¼ü³åÍ»µÄ¼Ç¼

delete from my_table_name where id not in(select id from (SELECT min(id) as id FROM my_table_name group by `col1`,`col2`) as t1) limit 1000;