insert into course values('1002','文学','99');
insert into course values('1001','经济','89');.
c)
insert into score values('001','1001','6');
insert into score values('001','1001','7');
insert into score values('002','1001','8');
d) update score set sno='003' where grade='8';
update score set cno='1003' where sno='002';
e) delete from student where sname='lisi';
4.
a) 管理---方案---表---在“方案”和“对象名”文本框中输入要删除的方案名或表名,选择需要删除的表,单机“删除”。
b) drop table student;
4.6 习题
1. AB 2. B 3 C 4. A 5. B
6. C 7 A 8 C 9. B 10. A