实现代码如下:
create table bak as (select * from test group by title having count(*)=1);
insert into bak (select * from test group by title having count(*)>1);
truncate table test;
insert into test select * from bak;
以上就是【删除mysql数据库中的重复数据记录】的全部内容了,欢迎留言评论进行交流!