create table student(sno char(9) primary key,
sname char(20) unique,
ssex char(2),
sage smallint,
sdept char(20));
--插入数据
insert into student values('200215121','李勇','男',20,'CS');
insert into student values('200215122','刘晨','男',19,'CS' );
insert into student values('200215123','王敏','女',18,'MA' );
insert into student values('200215124','张立','男',19,'IS');