--添加到students表数据
INSERT INTO students
VALUES(10101,NULL,'王晓芳','女','07-5月-1988','计算机');
INSERT INTO students
VALUES(10205,NULL,'李秋枫','男','25-11月-1990','自动化');
INSERT INTO students
VALUES(10102,10101,'刘春苹','女','12-8月-1991','计算机');
INSERT INTO students
VALUES(10301,NULL,'高山','男','08-10月-1990','机电工程');
--添加department表数据
INSERT INTO departments
VALUES(101,'信息工程','1号教学楼');
INSERT INTO departments
VALUES(102,'电气工程','2号教学楼');
INSERT INTO departments
VALUES(103,'机电工程','3号教学楼');
--添加teachers表数据
INSERT INTO teachers
VALUES(10101,'王彤','教授','01-9月-1990',1000,3000,101);
INSERT INTO teachers
VALUES(10104,'孔世杰','副教授','06-7月-1994',800,2700,101);
INSERT INTO teachers
VALUES(10103,'邹人文','讲师','21-1月-1996',600,2400,101);
INSERT INTO teachers
VALUES(10106,'韩冬梅','助教','01-8月-2001',500,1800,101);
--添加courses表数据
INSERT INTO courses
VALUES(10101,'计算机组成原理',4);
INSERT INTO courses
VALUES(10201,'自动控制原理',4);
INSERT INTO courses
VALUES(10301,'工程制图',3);
INSERT INTO courses
VALUES(10102,'C++语言程序设计',3);
INSERT INTO courses
VALUES(10202,'模拟电子技术',4);
--添加students_grade表数据
INSERT INTO students_grade
VALUES(10101,10101,87);
INSERT INTO students_grade
VALUES(10101,10201,100);
INSERT INTO students_grade
VALUES(10101,10301,79);
--添加grades表数据
INSERT INTO grades
VALUES(1,0,59,'不及格');
INSERT INTO grades
VALUES(2,60,69,'不及格');
INSERT INTO grades
VALUES(3,70,79,'不及格');
INSERT INTO grades
VALUES(4,80,89,'不及格');
INSERT INTO grades
VALUES(5,90,100,'不及格');
原文链接: https://www.cnblogs.com/xcre/archive/2012/02/26/2368386.html
欢迎关注
微信关注下方公众号,第一时间获取干货硬货;公众号内回复【pdf】免费获取数百本计算机经典书籍
原创文章受到原创版权保护。转载请注明出处:https://www.ccppcoding.com/archives/42590
非原创文章文中已经注明原地址,如有侵权,联系删除
关注公众号【高性能架构探索】,第一时间获取最新文章
转载文章受原作者版权保护。转载请注明原作者出处!