记录一下SQL SERVER和My Sql的表主键自增的设置方式:
SQL SERVER:
create table aynu_student(
s_id int primary key identity(1,1),
s_name varchar(32) not null,
s_pass varchar(32) not null,
s_sex varchar(4) not null,
s_idcard varchar(20) not null,
s_address varchar(100) not null,
s_nation varchar(25) not null,
s_pol_stat varchar(10) not null,
s_school_time varchar(10) not null,
s_household varchar(10) not null,
s_schoolmethod varchar(10) not null,
s_class varchar(10),
s_pic_path varchar(100),
delflag bit default 0,
foreign key(s_class) references aynu_classes(cs_id)
);
My Sql:
create table aynu_student(
s_id int primary key auto_increment,
s_name varchar(32) not null,
s_pass varchar(32) not null,
s_sex varchar(4) not null,
s_idcard varchar(20) not null,
s_address varchar(100) not null,
s_nation varchar(25) not null,
s_pol_stat varchar(10) not null,
s_school_time varchar(10) not null,
s_household varchar(10) not null,
s_schoolmethod varchar(10) not null,
s_class varchar(10),
s_pic_path varchar(100),
delflag bit default 0,
foreign key(s_class) references aynu_classes(cs_id)
);