1、使用distinct查询所有不重复的记录
2、创建数据表相同结构的临时表，将第一步的数据复制进去
create temporary table if not exists student_temp as (select distinct(name), sex from student);
3、truncate table student;
4、insert into student(id,name,sex) select null,name,sex from student_temp;
2022-01-11 04:08:54
1、使用distinct查询所有不重复的记录
2、创建数据表相同结构的临时表，将第一步的数据复制进去
create temporary table if not exists student_temp as (select distinct(name), sex from student);
3、truncate table student;
4、insert into student(id,name,sex) select null,name,sex from student_temp;