-
Notifications
You must be signed in to change notification settings - Fork 0
/
insert_into_table.sql
41 lines (30 loc) · 2.41 KB
/
insert_into_table.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
use vr2m;
INSERT INTO LOGIN_USER VALUES ('ali_stu', 'ali123', 'Alice', 'M', 'Lambert', '[email protected]', 'S');
INSERT INTO LOGIN_USER VALUES ('bob_stu', 'bob123', 'Bob', 'C', 'Reeves', '[email protected]', 'S');
INSERT INTO LOGIN_USER VALUES ('chr_stu', 'chr123', 'Chris', 'A', 'Campbell', '[email protected]', 'S');
INSERT INTO LOGIN_USER VALUES ('cen_ins', 'cen123', 'Cen', NULL , 'Li', '[email protected]', 'T');
INSERT INTO LOGIN_USER VALUES ('jos_ins', 'jos123', 'Joshua', NULL , 'Philips', '[email protected]', 'T');
INSERT INTO LOGIN_USER VALUES ('zhi_ins', 'zhi123', 'Zhijiang', NULL , 'Dong', '[email protected]', 'T');
INSERT INTO COURSES VALUES ('CSCI 3130', 'Visualization', 'This is scientific visualization.');
INSERT INTO COURSES VALUES ('CSCI 2170', 'Python', 'This is python.');
INSERT INTO COURSES VALUES ('CSCI 4560', 'C++', 'This is C++.');
INSERT INTO COURSES_THIS_SEM VALUES ('CSCI 2170', '81141', '001');
INSERT INTO COURSES_THIS_SEM VALUES ('CSCI 2170', '81142', '002');
INSERT INTO COURSES_THIS_SEM VALUES ('CSCI 3130', '81146', '001');
INSERT INTO COURSES_THIS_SEM VALUES ('CSCI 4560', '81159', '001');
INSERT INTO COURSE_WORK VALUES ('Homework6', '81141', '001', 'Homework6.pdf','2015-11-11', '2015-12-11', 'HW');
INSERT INTO COURSE_WORK VALUES ('Project6', '81142', '002', 'Project6.pdf','2015-11-12', '2015-12-12', 'PJ');
INSERT INTO COURSE_WORK VALUES ('ClosedLab10', '81146', '001', 'ClosedLab10.txt','2015-10-17', '2015-11-10', 'CL');
INSERT INTO COURSE_WORK VALUES ('ClosedLab11', '81146', '001', 'ClosedLab11.pdf','2015-11-17', '2015-12-10', 'CL');
INSERT INTO COURSE_WORK VALUES ('ResearchPaper1', '81159', '001', 'ResearchPaper.pdf','2015-10-01', '2015-12-16', 'RP');
INSERT INTO COURSE_WORK VALUES ('Homework7', '81159', '001', 'Homework7.doc', '2015-12-10', '2015-12-17', 'HW');
INSERT INTO COURSES_ENROLLED VALUES ('ali_stu', '81141', '001');
INSERT INTO COURSES_ENROLLED VALUES ('ali_stu', '81146', '001');
INSERT INTO COURSES_ENROLLED VALUES ('bob_stu', '81146', '001');
INSERT INTO COURSES_ENROLLED VALUES ('bob_stu', '81159', '001');
INSERT INTO COURSES_ENROLLED VALUES ('chr_stu', '81142', '002');
INSERT INTO COURSES_ENROLLED VALUES ('chr_stu', '81146', '001');
INSERT INTO COURSES_TEACHING VALUES ('cen_ins', '81141', '001');
INSERT INTO COURSES_TEACHING VALUES ('zhi_ins', '81142', '002');
INSERT INTO COURSES_TEACHING VALUES ('jos_ins', '81146', '001');
INSERT INTO COURSES_TEACHING VALUES ('zhi_ins', '81159', '001');