create table SC(
Sno char(10), /*创建表*/
Cno nchar(2),
Grade int,
)
insert into SC
values('201215122','3',80) /*增*/
insert into Course(Cno,Cname,Ccredit) /*带有NULL值的增*/
values('8','高等数学',4)
delete from SC where Grade=80 /*删*/
update SC set Grade=100 where Cno='1' /*改*/
update SC set Grade=100
Sno char(10), /*创建表*/
Cno nchar(2),
Grade int,
)
insert into SC
values('201215122','3',80) /*增*/
insert into Course(Cno,Cname,Ccredit) /*带有NULL值的增*/
values('8','高等数学',4)
delete from SC where Grade=80 /*删*/
update SC set Grade=100 where Cno='1' /*改*/
update SC set Grade=100
扫一扫
2万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
