MYSQL 当有两条重复数据时 保留一条

delete from test  where id in (select id from (select  max(id) as id,count(text) as count from test group by text having count >1 order by count desc) as tab )

测试代码

 INSERT IGNORE INTO test_1(text,text2) values ('1111','22222');

 INSERT IGNORE INTO test_1(text,text2) values ('1111','22222');

 INSERT IGNORE INTO test_1(text,text2) values ('1111','22222');

 INSERT IGNORE INTO test_1(text,text2) values ('1111','22222');

 INSERT IGNORE INTO test_1(text,text2) values ('1111','22222');

 INSERT IGNORE INTO test_1(text,text2) values ('1111','33333');

 INSERT IGNORE INTO test_1(text,text2) values ('1111','33333');

 INSERT IGNORE INTO test_1(text,text2) values ('1111','33333');

 INSERT IGNORE INTO test_1(text,text2) values ('1111','33333');

 INSERT IGNORE INTO test_1(text,text2) values ('1111','33333');

 INSERT IGNORE INTO test_1(text,text2) values ('1111','33333');

 INSERT IGNORE INTO test_1(text,text2) values ('1111','33333');

 INSERT IGNORE INTO test_1(text,text2) values ('22222','33333');

 INSERT IGNORE INTO test_1(text,text2) values ('22222','33333');

 INSERT IGNORE INTO test_1(text,text2) values ('22222','33333');

 INSERT IGNORE INTO test_1(text,text2) values ('22222','33333');

 INSERT IGNORE INTO test_1(text,text2) values ('22222','33333');

 INSERT IGNORE INTO test_1(text,text2) values ('22222','33333');

 REPLACE  INTO test(text) values ('1111')

delete from test

select * from test_1 where text='1111'

select * from test_1 where text='22222'

while 

delete

from test_1  where id in (select id from (select  max(id) as

id,count(text) as count from test_1 where text = '22222' group by

text,text2 having count >1 order by count desc) as tab );

delete

from test_1  where id in (select id from (select  max(id) as

id,count(text) as count from test_1 where text = '22222' group by

text,text2 having count >1 order by count desc) as tab );

delete

from test_1  where id in (select id from (select  max(id) as

id,count(text) as count from test_1 where text = '22222' group by

text,text2 having count >1 order by count desc) as tab );

delete

from test_1  where id in (select id from (select  max(id) as

id,count(text) as count from test_1 where text = '22222' group by

text,text2 having count >1 order by count desc) as tab );

delete

from test_1  where id in (select id from (select  max(id) as

id,count(text) as count from test_1 where text = '22222' group by

text,text2 having count >1 order by count desc) as tab );

delete

from test_1  where id in (select id from (select  max(id) as

id,count(text) as count from test_1 where text = '22222' group by

text,text2 having count >1 order by count desc) as tab );

delete

from test_1  where id in (select id from (select  max(id) as

id,count(text) as count from test_1 where text = '22222' group by

text,text2 having count >1 order by count desc) as tab );

delete

from test_1  where id in (select id from (select  max(id) as

id,count(text) as count from test_1 where text = '22222' group by

text,text2 having count >1 order by count desc) as tab );

©著作权归作者所有,转载或内容合作请联系作者
【社区内容提示】社区部分内容疑似由AI辅助生成，浏览时请结合常识与多方信息审慎甄别。
平台声明：文章内容（如有图片或视频亦包括在内）由作者上传并发布，文章内容仅代表作者本人观点，简书系信息发布平台，仅提供信息存储服务。

相关阅读更多精彩内容

友情链接更多精彩内容