网页 尤其是这种更换后台之类的做法 网站中的url是要保证不会变化的 如果按照你的做法做 那么id必然会出现变化 id变化 网页的url就会发生变化 与预期要求不符 我已经找到答案了
create table linshi as select * from yuanbiao group by id having count(id) = 1;
insert into linshi select * from yuanbiao group by id having count(id) > 1;
delete from yuanbiao;
insert into yuanbiao select * from linshi;
