create table s
(sno char(9) primary key,sname char(20),sage smallint,ssex char(2))
select cno,cname from c where teacher='刘强'
select sno,sname from s where sage<22 and ssex='女'
select * from s where sname like '刘%'
alter table s add sdept char(20)
alter table sc add constraint CK_stugrade check (grade between 0 and 100)
insert into s(sno,sname,sage,ssex)
values('001','张三',19,'男')
update s set sdept='水利水电工程' where ssex='女'
delete from s
drop table s
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024