코드 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'),
    ...
    신간 소식 구독하기
    뉴스레터에 가입하시고 이메일로 신간 소식을 받아 보세요.