首相将数据备份;
一、创建一张字段一样的表
create table t_student_bak (id int,name varchar(100))
二、备份之前表数据
insert into t_student_bak select * from t_student
三、根据rowid删除重复的数据
delete from t_student where rowid not in (select min(rowid) from t_student group by id);
首相将数据备份;
一、创建一张字段一样的表
create table t_student_bak (id int,name varchar(100))
二、备份之前表数据
insert into t_student_bak select * from t_student
三、根据rowid删除重复的数据
delete from t_student where rowid not in (select min(rowid) from t_student group by id);