insert record

INSERT INTO dept_info VALUES ('01','计算机系');
INSERT INTO dept_info VALUES ('02','商务系');
INSERT INTO dept_info VALUES ('03','会计系');
INSERT INTO dept_info VALUES ('04','外语系');

INSERT INTO specialty_info VALUES('0101','软件技术');
INSERT INTO specialty_info VALUES('0102','计算机应用');
INSERT INTO specialty_info VALUES('0201','国际经济与贸易');
INSERT INTO specialty_info VALUES('0202','国际报关');
INSERT INTO specialty_info VALUES('0203','电子商务');
INSERT INTO specialty_info VALUES('0301','会计电算化');
INSERT INTO specialty_info VALUES('0302','会计');
INSERT INTO specialty_info VALUES('0303','财务管理');
INSERT INTO specialty_info VALUES('0304','投资与理财');
INSERT INTO specialty_info VALUES('0401','商务英语');
INSERT INTO specialty_info VALUES('0402','旅游英语');

INSERT INTO student_info
(dept_no,s_no,s_name,s_sex,s_birthday,s_address,s_tel,s_email,spec_no,in_cj）
VALUES('01','201001001','张小三','男','05-8月-1992','吉林省长春市', '0431-********','zs@https://www.doczj.com/doc/412085586.html,','01001',450）;

INSERT INTO student_info
(dept_no,s_no,s_name,s_sex,s_birthday,s_address,s_tel,s_email,spec_no,in_cj)
VALUES('01','201001002','李四','男','25-2月-1993','吉林省长春市', '0431-********','ls@https://www.doczj.com/doc/412085586.html,','01001',442);

INSERT INTO student_info
(dept_no,s_no,s_name,s_sex,s_birthday,s_address,s_tel,s_email,spec_no,in_cj)
VALUES('02','201002001','许三多','男','15-8月-1993','辽宁省沈阳市', '024-********','xsd@https://www.doczj.com/doc/412085586.html,','02001',468);

INSERT INTO student_info
(dept_no,s_no,s_name,s_sex,s_birthday,s_address,s_tel,s_email,spec_no,in_cj)
VALUES('02','201002002','张国','男','05-2月-1991','辽宁省沈阳市', '024-********','zg@https://www.doczj.com/doc/412085586.html,','02001',420);
INSERT INTO student_info
(dept_no,s_no,s_name,s_sex,s_birthday,s_address,s_tel,s_email,spec_no,in_cj)
VALUES('02','201002005','王芳','女','13-6月-1993','江苏省苏州市', '0512-********','wf@https://www.doczj.com/doc/412085586.html,','02002',460);

INSERT INTO student_info
(dept_no,s_no,s_name,s_sex,s_birthday,s_address,s_tel,s_email,spec_no,in_cj)
VALUES('02','200902001','张清山','男','09-4月-1991','上海市', '021-********','zqs@https://www.doczj.com/doc/412085586.html,','02001',420);

INSERT INTO course_lb_info VALUES('01','公共基础课');
INSERT INTO course_lb_info VALUES('02','专业基础课');
INSERT INTO course_lb_info VALUES('03','专业技能课');
INSERT INTO course_lb_info VALUES('04','选修课');

INSERT INTO course_info VALUES('01001','高等数学','01','01001','01');
INSERT INTO course_info VALUES('01002','英语','01','01001','01');
INSERT INTO course_info VALUES('01003','政治经济学','01','01001','01');
INSERT INTO course_info VALUES('01004','C语言程序设计','01','01001','02');
INSERT INTO course_info VALUES('01005','数据结构','01','01001','02');
INSERT INTO course_info VALUES('01006','SQL Server数据库','01','01001','03');
INSERT INTO course_info VALUES('01007','Oracle数据库','01','01001','03');

INSERT INTO course_info VALUES('01008','Java语言','01','01001','03');

INSERT INTO cj_info VALUES('201001001','01002',71,'01','13-1月-2011');
INSERT INTO cj_info VALUES('201001002','01001',91,'01','13-1月-2011');
INSERT INTO cj_info VALUES('201001001','01001',80,'01','13-1月-2011');
INSERT INTO cj_info VALUES('201001003','01001',60,'01','13-1月-2011');

INSERT INTO course_selection_info VALUES
('1','01004','20100101','201001','060301',50,'060301','10-6月-2010','060301', '10-6月-2010');
INSERT INTO course_selection_info VALUES
('2','01005','20100101','201001','060302',50,'060301','10-6月-2010','060302', '10-6月-2010');
INSERT INTO course_selection_info VALUES
('3','01006','20100102','201001','060302',42,'060301','10-6月-2010','060302', '10-6月-2010');

INSERT INTO class_info VALUES('20100101','2010软件1班',50,'01001');
INSERT INTO class_info VALUES('20100102','2010软件2班',42,'01001');

INSERT INTO teacher_info VALUES('060301','张家赫','01','男');
INSERT INTO teacher_info VALUES('060302','李清涛','01','男');