mysql数据表去重

应用场景：根据某几个字段唯一，删除其他重复行

#删除可能已创建的表

drop table IF EXISTS `your_table_duplicate`;

#创建临时表,根据key1,key2,key3等进行唯一筛选，且重复时取出较大id的一个

create table your_table_duplicate as (select max(id) from your_table group by key1,key2,key3 having count(*)>1);

#删除重复的id

delete from your_table WHERE id in (SELECT `max(id)` as id FROM `your_table_duplicate`);

#删除临时表

drop table IF EXISTS `your_table_duplicate`;