Student-Enrollment-System/insert_sections.sql at master · xiaojiantou/Student-Enrollment-System · GitHub

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
INSERT INTO `enrollment system`.`sections` (call_no, course_id, section_no, year, semester, day, start_time, end_time)
VALUES ('00002','COMSE1006',1, 2016, 2, 'W', 1130, 1400);
INSERT INTO `enrollment system`.`sections` (call_no, course_id, section_no, year, semester, day, start_time, end_time)
VALUES ('00003','COMSE1006',2, 2017,1, 'M', 1430,1700);
INSERT INTO `enrollment system`.`sections` (call_no, course_id, section_no, year, semester, day, start_time, end_time)
VALUES ('00004','COMSV9123',1, 2017,1, 'T', 830, 1100);
INSERT INTO `enrollment system`.`sections` (call_no, course_id, section_no, year, semester, day, start_time, end_time)
VALUES ('00005','COMSV9123',2, 2017,2, 'M', 1130, 1400);
INSERT INTO `enrollment system`.`sections` (call_no, course_id, section_no, year, semester, day, start_time, end_time)
VALUES ('00006','COMSW3270',1, 2016,4, 'T', 1430, 1700);
INSERT INTO `enrollment system`.`sections` (call_no, course_id, section_no, year, semester, day, start_time, end_time)
VALUES ('00007','COMSW3270',2, 2017,4, 'R', 1700, 1930 );
INSERT INTO `enrollment system`.`sections` (call_no, course_id, section_no, year, semester, day, start_time, end_time)
VALUES ('00008','COMSW4111',1, 2017, 3, 'R', 900, 1130);
INSERT INTO `enrollment system`.`sections` (call_no, course_id, section_no, year, semester, day, start_time, end_time)
VALUES ('00009','COMSW4111',2,2017,1, 'M', 1430,1700);
INSERT INTO `enrollment system`.`sections` (call_no, course_id, section_no, year, semester, day, start_time, end_time)
VALUES ('00010','ECONX6666',1, 2016,2, 'R', 900, 1130);
INSERT INTO `enrollment system`.`sections` (call_no, course_id, section_no, year, semester, day, start_time, end_time)
VALUES ('00011','ECONX6666',2, 2017,1, 'M', 1430,1700);
INSERT INTO `enrollment system`.`sections` (call_no, course_id, section_no, year, semester, day, start_time, end_time)
VALUES ('00012','EENGV2321',1, 2016,1, 'T', 1500, 1730);
INSERT INTO `enrollment system`.`sections` (call_no, course_id, section_no, year, semester, day, start_time, end_time)
VALUES ('00013','EENGV2321',2, 2016, 3, 'M', 1200, 1430);
INSERT INTO `enrollment system`.`sections` (call_no, course_id, section_no, year, semester, day, start_time, end_time)
VALUES ('00014','EENGV6239',1, 2017,1, 'W', 1800, 2030);
INSERT INTO `enrollment system`.`sections` (call_no, course_id, section_no, year, semester, day, start_time, end_time)
VALUES ('00015','EENGV6239',2, 2017,1, 'T', 830, 1100);
INSERT INTO `enrollment system`.`sections` (call_no, course_id, section_no, year, semester, day, start_time, end_time)
VALUES ('00016','MATHBC0123',1, 2016, 1, 'F', 900, 1130);
INSERT INTO `enrollment system`.`sections` (call_no, course_id, section_no, year, semester, day, start_time, end_time)
VALUES ('00017','MATHBC0123',2, 2017,1, 'F', 1400,1630);
INSERT INTO `enrollment system`.`sections` (call_no, course_id, section_no, year, semester, day, start_time, end_time)
VALUES ('00018','PHYSE0452',1, 2016, 2, 'R', 900, 1130);
INSERT INTO `enrollment system`.`sections` (call_no, course_id, section_no, year, semester, day, start_time, end_time)
VALUES ('00019','PHYSE0452',2, 2017, 1, 'T', 830, 1100);