插入数据
--添加数据
--学生表S
use student_data
insert into S(sno,sname,sgender,sage,college)
values('0811101','李勇','男',19,'计算机系');
insert into S(sno,sname,sgender,sage,college)
values('0811102','王叶','男',18,'计算机系');
insert into S(sno,sname,sgender,sage,college)
values('0811103','王敏','女',19,'计算机系');
insert into S(sno,sname,sgender,sage,college)
values('0811104','张小红','女',17,'计算机系');
insert into S(sno,sname,sgender,sage,college)
values('0821101','张立','男',19,'信息管理系');
insert into S(sno,sname,sgender,sage,college)
values('0821102','吴宾','女',18,'信息管理系');
insert into S(sno,sname,sgender,sage,college)
values('0821103','张海','男',18,'信息管理系');
insert into S(sno,sname,sgender,sage,college)
values('0831101','钱小平','女',19,'通信工程系');
insert into S(sno,sname,sgender,sage,college)
values('0831102','王大力','男',19,'通信工程系');
insert into S(sno,sname,sgender,sage,college)
values('0831103','张珊珊','女',18,'通信工程系');
insert into S(sno,sname,sgender,sage,college)
values('0811110','外加的','女',19,'外加系');
insert into S(sno,sname,sgender,sage,college)
values('03062113','嘟嘟嘟','女',19,'计算机系');
--select * from S
--delete from S
--课程表C
use student_data
insert into C(cno,cname,ccredit,cpno,description)
values('c001','高等数学',8,NULL,NULL);
--不能插入重复列(大学英语)
insert into C(cno,cname,ccredit,cpno,description)
values('c002','大学英语',3,NULL,NULL);
insert into C(cno,cname,ccredit,cpno,description)
values('c003','大学英语2',3,NULL,NULL);
insert into C(cno,cname,ccredit,cpno,description)
values('c004','计算机文化学',2,'c002',NULL);
insert into C(cno,cname,ccredit,cpno,description)
values('c005','Java',2,NULL,NULL);
/* --删除外键约束
alter table C
add constraint FK_cpno foreign key(cpno) references C(cno) --起名
alter table C
drop constraint FK_cpno
*/
insert into C(cno,cname,ccredit,cpno,description)
values('c006','数据库基础',4,NULL,NULL);
insert into C(cno,cname,ccredit,cpno,description)
values('c007','数据结构',4,NULL,NULL);
insert into C(cno,cname,ccredit,cpno,description)
values('c008','计算机网络',4,'c004',NULL);
--select * from C
--delete from C
--选修表SC
use student_data
insert into SC(id,sno,cno,grade)
values(1,'0811101','c001',96);
insert into SC(id,sno,cno,grade)
values(2,'0811101','c002',96);
insert into SC(id,sno,cno,grade)
values(3,'0811101','c003',92);
insert into SC(id,sno,cno,grade)
values(4,'0811101','c005',92);
insert into SC(id,sno,cno,grade)
values(5,'0811102','c001',92);
insert into SC(id,sno,cno,grade)
values(6,'0811102','c002',90);
insert into SC(id,sno,cno,grade)
values(7,'0811102','c004',84);
insert into SC(id,sno,cno,grade)
values(8,'0811110','c001',96);
insert into SC(id,sno,cno,grade)
values(9,'0821102','c001',76);
insert into SC(id,sno,cno,grade)
values(10,'0821102','c004',85);
insert into SC(id,sno,cno,grade)
values(11,'0821102','c005',73);
insert into SC(id,sno,cno,grade)
values(12,'0821102','c007',null);
insert into SC(id,sno,cno,grade)
values(13,'0821103','c001',50);
insert into SC(id,sno,cno,grade)
values(14,'0821103','c004',80);
insert into SC(id,sno,cno,grade)
values(15,'0831101','c001',50);
insert into SC(id,sno,cno,grade)
values(16,'0831101','c001',80);
insert into SC(id,sno,cno,grade)
values(17,'0831102','c007',null);
insert into SC(id,sno,cno,grade)
values(18,'0831103','c007',78);
insert into SC(id,sno,cno,grade)
values(19,'0831103','c005',65);
insert into SC(id,sno,cno,grade)
values(20,'0831103','c007',null);
select * from SC
--select * from SC
--delete from SC