mysql数据表去重
作者:bin应用场景:根据某几个字段唯一,删除其他重复行
#删除可能已创建的表
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`;