Skip to content

Data! 모두 합침 #8

New issue
New issue
Open
Open
Data! 모두 합침#8
@estanie

Description

@estanie
estanie
opened on Jun 14, 2017

INSERT INTO STUDENTS VALUES(1410845,'asdfasdf','안지후','소프트웨어학부','경기도 분당시 ','[email protected]');
INSERT INTO STUDENTS VALUES(1411893,'qwerqwer','이다영','소프트웨어학부','경기도 수원시','[email protected]');
INSERT INTO STUDENTS VALUES(1413511,'123123','이가연','소프트웨어학부','서울시 용산구','[email protected]');
INSERT INTO STUDENTS VALUES(1410463,'trewq','이지완','통계학과','서울시 강남구','[email protected]');
INSERT INTO STUDENTS VALUES(1510533,'q1w2e3','김효민','피아노과','서울시 마포구','[email protected]');
INSERT INTO STUDENTS VALUES(1616412,'1q2w3e','이혜진','무용과','서울시 서초구','[email protected]');
INSERT INTO STUDENTS VALUES(1515678,'4r5t6y','유해진','간호학과','경기도 광주시','[email protected]');
INSERT INTO STUDENTS VALUES(1614401,'fffff','강동원','영화과','대전시 유성구','[email protected]');

INSERT INTO PROFESSOR VALUES(20170101,'fdajkl','심준호','소프트웨어학부','[email protected]');
INSERT INTO PROFESSOR VALUES(20170102,'ajdks','이기용','소프트웨어학부','[email protected]');
INSERT INTO PROFESSOR VALUES(20170103,'123wer','문봉희','무용과','[email protected]');
INSERT INTO PROFESSOR VALUES(20170104,'jkljkl','김윤희','심리학과','[email protected]');
INSERT INTO PROFESSOR VALUES(20170105,'zxczxc','유석종','약학과','[email protected]');
INSERT INTO PROFESSOR VALUES(20170106,'tyui','이광수','IT공학부','[email protected]');
INSERT INTO PROFESSOR VALUES(20170107,'jjjj','이주은','심리학과','[email protected]');
INSERT INTO PROFESSOR VALUES(20170108,'fjfjfj','홍광호','실용음악학과','[email protected]');
INSERT INTO PROFESSOR VALUES(20170109,'digg','김주균','호텔관광학부','[email protected]');
INSERT INTO PROFESSOR VALUES(20170110,'kokoko','이은자','기초교양학부','[email protected]');
INSERT INTO PROFESSOR VALUES(20170111,'hhhh','이행복','사회심리학과','[email protected]');
INSERT INTO PROFESSOR VALUES(20170112,'asgjdsk','박정은','한국어문학부','[email protected]');

INSERT INTO COURSE VALUES('C800',01,3,'수치해석');
INSERT INTO COURSE VALUES('C800',02,3,'수치해석');
INSERT INTO COURSE VALUES('P101',01,3,'운영체제');
INSERT INTO COURSE VALUES('B456',01,3,'프로그래밍언어론');
INSERT INTO COURSE VALUES('A123',01,3,'컴퓨터수학');
INSERT INTO COURSE VALUES('A123',02,3,'컴퓨터수학');
INSERT INTO COURSE VALUES('Q711',01,3,'데이터베이스');
INSERT INTO COURSE VALUES('F500',01,3,'웹시스템설계');
INSERT INTO COURSE VALUES('F500',02,3,'웹시스템설계');
INSERT INTO COURSE VALUES('F500',03,3,'웹시스템설계');
INSERT INTO COURSE VALUES('E779',01,3,'소프트웨어공학');
INSERT INTO COURSE VALUES('E779',02,3,'소프트웨어공학');
INSERT INTO COURSE VALUES('U777',01,3,'컴퓨터활용');
INSERT INTO COURSE VALUES('W002',01,3,'컴퓨터과학의이해');
INSERT INTO COURSE VALUES('W002',02,3,'컴퓨터과학의이해');
INSERT INTO COURSE VALUES('Q111',01,3,'수학개론');
INSERT INTO COURSE VALUES('R453',01,3,'일본대중문화기행');
INSERT INTO COURSE VALUES('E222',01,3,'공예감상');
INSERT INTO COURSE VALUES('E222',02,3,'공예감상');
INSERT INTO COURSE VALUES('S789',01,3,'UI/UX디자인');
INSERT INTO COURSE VALUES('A555',01,3,'미적분학');
INSERT INTO COURSE VALUES('O888',01,3,'경제학개론');
INSERT INTO COURSE VALUES('O888',02,3,'경제학개론');
INSERT INTO COURSE VALUES('O888',03,3,'경제학개론');
INSERT INTO COURSE VALUES('S100', 01, 3, '소프트웨어의이해');
INSERT INTO COURSE VALUES('S100', 02, 3, '소프트웨어의이해');
INSERT INTO COURSE VALUES('S100', 03, 3, '소프트웨어의이해');
INSERT INTO COURSE VALUES('S890', 01, 3, '자료구조');
INSERT INTO COURSE VALUES('S890', 02, 3, '자료구조');
INSERT INTO COURSE VALUES('S333', 01, 3, '인공지능');
INSERT INTO COURSE VALUES('S333', 02, 3, '인공지능');
INSERT INTO COURSE VALUES('C178', 01, 3, '교양요가');
INSERT INTO COURSE VALUES('C178', 02, 3, '교양요가');
INSERT INTO COURSE VALUES('C209', 01, 3, '교양승마');
INSERT INTO COURSE VALUES('P555', 01, 3, '심리학개론');
INSERT INTO COURSE VALUES('P555', 02, 3, '심리학개론');
INSERT INTO COURSE VALUES('A464', 01, 3, '데이터베이스프로그래밍');
INSERT INTO COURSE VALUES('A464', 02, 3, '데이터베이스프로그래밍');
INSERT INTO COURSE VALUES('A464', 03, 3, '데이터베이스프로그래밍');
INSERT INTO COURSE VALUES('Q139', 01, 3, '컴파일러');
INSERT INTO COURSE VALUES('Q139', 02, 3, '컴파일러');
INSERT INTO COURSE VALUES('B500', 01, 3, '서양미술사');
INSERT INTO COURSE VALUES('B500', 02, 3, '서양미술사');
INSERT INTO COURSE VALUES('D477', 01, 3, '해부학');
INSERT INTO COURSE VALUES('D477', 02, 3, '해부학');
INSERT INTO COURSE VALUES('D477', 03, 3, '해부학');
INSERT INTO COURSE VALUES('D477', 04, 3, '해부학');
INSERT INTO COURSE VALUES('Y612', 01, 3, '프로그래밍개론');
INSERT INTO COURSE VALUES('G111', 01, 3, '취업설계');
INSERT INTO COURSE VALUES('G111', 02, 3, '취업설계');
INSERT INTO COURSE VALUES('G265', 01, 3, '영어쓰기와읽기');
INSERT INTO COURSE VALUES('G265', 02, 3, '영어쓰기와읽기');
INSERT INTO COURSE VALUES('G265', 03, 3, '영어쓰기와읽기');
INSERT INTO COURSE VALUES('F133', 01, 3, '컴퓨터네트워크');
INSERT INTO COURSE VALUES('F133', 02, 3, '컴퓨터네트워크');
INSERT INTO COURSE VALUES('R555', 01, 3, '웹사이트이해와활용');

INSERT INTO teach
VALUES ('C800',01,20170102,2017,1,4,2,60,'새힘관B101');
INSERT INTO teach
VALUES ('C800',02,20170102,2017,1,5,2,60,'새힘관B101');
INSERT INTO teach
VALUES ('P101',01,20170109,2017,1,3,2,50,'명신관413');
INSERT INTO teach
VALUES ('B456',01,20170103,2017,1,1,1,50,'명신관309');
INSERT INTO teach
VALUES ('A123',01,20170106,2017,2,1,2,30,'명신관309');
INSERT INTO teach
VALUES ('A123',02,20170105,2017,2,3,2,30,'진리관209');
INSERT INTO teach
VALUES ('Q711',01,20170101,2017,1,4,1,32,'명신관414');
INSERT INTO teach
VALUES ('F500',01,20170104,2017,1,3,2,32,'명신관408');
INSERT INTO teach
VALUES ('F500',02,20170104,2017,1,4,2,32,'명신관408');
INSERT INTO teach
VALUES ('F500',01,20170109,2017,1,4,2,32,'명신관305');
INSERT INTO teach
VALUES ('E779',01,20170102,2017,1,3,1,40,'명신관309');
INSERT INTO teach
VALUES ('E779',02,20170102,2017,1,7,2,40,'명신관309');
INSERT INTO teach
VALUES ('U777',01,20170102,2017,1,1,3,40,'명신관101');
INSERT INTO teach
VALUES ('W002',01,20170101,2017,1,6,1,55,'과학관651');
INSERT INTO teach
VALUES ('W002',02,20170102,2017,1,6,2,55,'과학관612');
INSERT INTO teach
VALUES ('Q111',01,20170111,2017,2,3,3,100,'과학관105');
INSERT INTO teach
VALUES ('R453',01,20170112,2017,1,5,2,80,'명신관425');
INSERT INTO teach
VALUES ('E222',01,20170108,2017,1,1,3,50,'미술대학207');
INSERT INTO teach
VALUES ('O888',01,20170111,2017,1,5,1,100,'순헌관511');
INSERT INTO teach
VALUES ('O888',02,20170106,2017,1,6,1,100,'순헌관511');
INSERT INTO teach
VALUES ('O888',03,20170112,2017,1,5,3,80,'진리관304');
INSERT INTO teach
VALUES ('S100',01,20170102,2017,2,4,2,60,'명신관308');
INSERT INTO teach
VALUES ('S100',02,20170102,2017,2,6,2,60,'명신관308');
INSERT INTO teach
VALUES ('S100',03,20170102,2017,2,2,2,60,'명신관403');
INSERT INTO teach
VALUES ('S890',01,20170111,2017,1,1,3,75,'순헌관408');
INSERT INTO teach
VALUES ('S890',02,20170111,2017,1,5,3,75,'순헌관408');
INSERT INTO teach
VALUES ('S333',01,20170105,2017,1,2,2,50,'진리관B101');
INSERT INTO teach
VALUES ('S333',02,20170105,2017,1,5,2,50,'진리관B102');
INSERT INTO teach
VALUES ('C178',01,20170112,2017,1,4,2,60,'진리관B103');
INSERT INTO teach
VALUES ('C178',02,20170112,2017,1,7,2,60,'진리관B103');
INSERT INTO teach
VALUES ('C209',01,20170110,2017,2,2,3,65,'명신관306');
INSERT INTO teach
VALUES ('P555',01,20170108,2017,2,3,2,35,'명신관402');
INSERT INTO teach
VALUES ('P555',02,20170108,2017,2,1,2,35,'명신관402');
INSERT INTO teach
VALUES ('A464',01,20170105,2017,1,6,2,100,'진리관311');
INSERT INTO teach
VALUES ('A464',02,20170105,2017,1,5,2,100,'진리관311');
INSERT INTO teach
VALUES ('A464',03,20170105,2017,1,4,2,100,'진리관311');
INSERT INTO teach
VALUES ('Q139',01,20170103,2017,2,2,1,50,'음악대학601');
INSERT INTO teach
VALUES ('Q139',02,20170103,2017,2,1,1,50,'음악대학601');
INSERT INTO teach
VALUES ('B500',01,20170104,2017,2,3,2,70,'새힘관B102');
INSERT INTO teach
VALUES ('B500',02,20170104,2017,2,5,2,70,'새힘관B102');
INSERT INTO teach
VALUES ('Z612',01,20170106,2017,2,3,2,80,'진리관504');
INSERT INTO teach
VALUES ('D477',01,20170107,2017,2,1,3,40,'명신관421');
INSERT INTO teach
VALUES ('D477',02,20170107,2017,2,3,3,40,'명신관421');
INSERT INTO teach
VALUES ('D477',03,20170107,2017,2,4,3,40,'명신관418');
INSERT INTO teach
VALUES ('D477',04,20170107,2017,2,6,3,40,'명신관418');
INSERT INTO teach
VALUES ('Y612',01,20170111,2017,2,2,1,80,'과학관302');
INSERT INTO teach
VALUES ('G111',01,20170110,2017,2,3,2,55,'과학관412');
INSERT INTO teach
VALUES ('G111',02,20170110,2017,2,3,2,55,'과학관412');
INSERT INTO teach
VALUES ('G265',01,20170101,2017,1,3,2,25,'과학관404');
INSERT INTO teach
VALUES ('G265',02,20170101,2017,1,7,2,25,'과학관404');
INSERT INTO teach
VALUES ('G265',03,20170101,2017,1,6,2,25,'과학관404');
INSERT INTO teach
VALUES ('F133',01,20170109,2017,2,2,1,60,'미술대학212');
INSERT INTO teach
VALUES ('F133',02,20170109,2017,2,3,1,60,'미술대학212');

INSERT INTO enroll
VALUES (1616412,'E222',01,2017,1);
INSERT INTO enroll
VALUES (1616412,'G111',02,2017,2);
INSERT INTO enroll
VALUES (1616412,'Y612',01,2017,2);
INSERT INTO enroll
VALUES (1614401,'R555',01,2017,2);
INSERT INTO enroll
VALUES (1413511,'B500',02,2017,2);
INSERT INTO enroll
VALUES (1614401,'Z612',01,2017,2);
INSERT INTO enroll
VALUES (1410463,'B500',01,2017,2);
INSERT INTO enroll
VALUES (1510533,'D477',04,2017,2);
INSERT INTO enroll
VALUES (1410845,'Q139',01,2017,2);
INSERT INTO enroll
VALUES (1515678,'F133',02,2017,2);

INSERT INTO enroll
VALUES (1410845,'E222',02,2017,1);
INSERT INTO enroll
VALUES (1411893,'E222',02,2017,1);
INSERT INTO enroll
VALUES (1413511,'E222',02,2017,1);
INSERT INTO enroll
VALUES (1410463,'E222',01,2017,1);
INSERT INTO enroll
VALUES (1614401,'E222',01,2017,1);
INSERT INTO enroll
VALUES (1614401,'U777',01,2017,1);
INSERT INTO enroll
VALUES (1614401,'W002',02,2017,1);
INSERT INTO enroll
VALUES (1410845,'W002',01,2017,1);
INSERT INTO enroll
VALUES (1410845,'P101',01,2017,1);
INSERT INTO enroll
VALUES (1410845,'O888',03,2017,1);
INSERT INTO enroll
VALUES (1410845,'U777',01,2017,1);

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions