#//对数据进行排序
set @i = 0;
update student set id = (@i:=@i+1);
#//设置自增初始值
ALTER table student AUTO_INCREMENT = 1;
#//对数据进行排序
set @i = 0;
update student set id = (@i:=@i+1);
#//设置自增初始值
ALTER table student AUTO_INCREMENT = 1;