mysql删除表中造成唯一键冲突的记录

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