我想编个脚本,内容是创建一个学生表!创建好后删除某一个学生内容,但是删除后的ID号还是从1开始计数!例如:create table student(ID varchar(10) not null primary key,Name varchar(20) not null,Sex varchar(2) not null)insert into student values('1','aaa','男')insert into student values('2','bba','男')insert into student values('3','bbb','男')insert into student values('4','abb','男')delete from student where ID = '2'现在表内结果应为:1,aaa,男3,bbb,男4,abb,男而我要的结果是:1,aaa,男2,bbb,男3,abb,男请帮帮我,谢谢!

建表的时候设置主键ID列为自动增长CREATE TABLE T1 ( ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 0, INCREMENT BY 1, NO CACHE ) ,PRIMARY KEY ( ID) ) ;这样ID列就是自动增长了