create table student
(
Sid varchar(10) primary key not null,
SName varchar(10) not null,
SAge int constraint ck_age check(SAge>=10 and SAge<=60) not null,
Account varchar(10) constraint wy_account unique not null ,
Pwd varchar(15) not null,
Question varchar(20) not null,
Answer varchar(20) not null
)
学生登录SQL语句,包括check约束,唯一索引,主键
最新推荐文章于 2023-06-03 12:41:19 发布