mysql 根据两个字段去重

delete from table where id not in( select id from table group by  column1, column2 having

count(column1) > 1  and count(column2) >1);