더북(TheBook)

코드 4-19 04.dept_manager_insert.sql(일부)

INSERT INTO `dept_manager` VALUES
(110022, 'd001', '1985-01-01', '1991-10-01'),
(110039, 'd001', '1991-10-01', '9999-01-01'),
(110085, 'd002', '1985-01-01', '1989-12-17'),
(110114, 'd002', '1989-12-17', '9999-01-01'),
(110183, 'd003', '1985-01-01', '1992-03-21'),
(110228, 'd003', '1992-03-21', '9999-01-01'),
...

코드 4-20 05.dept_emp_insert.sql(일부)

INSERT INTO `dept_emp` VALUES
(10001, 'd005', '1986-06-26', '9999-01-01'),
(10002, 'd007', '1996-08-03', '9999-01-01'),
(10003, 'd004', '1995-12-03', '9999-01-01'),
(10004, 'd004', '1986-12-01', '9999-01-01'),
(10005, 'd003', '1989-09-12', '9999-01-01'),
(10006, 'd005', '1990-08-05', '9999-01-01'),
...

코드 4-21 06.titles_insert.sql(일부)

INSERT INTO `titles` VALUES
(10001, 'Senior Engineer', '1986-06-26', '9999-01-01'),
(10002, 'Staff', '1996-08-03', '9999-01-01'),
(10003, 'Senior Engineer', '1995-12-03', '9999-01-01'),
(10004, 'Engineer', '1986-12-01', '1995-12-01'),
(10004, 'Senior Engineer', '1995-12-01', '9999-01-01'),
(10005, 'Senior Staff', '1996-09-12', '9999-01-01'),
...
신간 소식 구독하기
뉴스레터에 가입하시고 이메일로 신간 소식을 받아 보세요.