代码如下:
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;
猜你喜欢