建表准备
create database nk_exe;
use nk_exe;
CREATE TABLE `employees` (
`emp_no` INT (11) NOT NULL,
`birth_date` DATE NOT NULL,
`first_name` VARCHAR (14) NOT NULL,
`last_name` VARCHAR (16) NOT NULL,
`gender` CHAR(1) NOT NULL,
`hire_date` DATE NOT NULL,
PRIMARY KEY (`emp_no`)
) ;
CREATE TABLE `dept_emp` (
`emp_no` INT (11) NOT NULL,
`dept_no` CHAR(4) NOT NULL,
`from_date` DATE NOT NULL,
`to_date` DATE NOT NULL,
PRIMARY KEY (`emp_no`, `dept_no`)
) ;
CREATE TABLE `dept_manager` (
`dept_no` CHAR(4) NOT NULL,
`emp_no` INT (11) NOT NULL,
`from_date` DATE NOT NULL,
`to_date` DATE NOT NULL,
PRIMARY KEY (`emp_no`, `dept_no`)
) ;
CREATE TABLE `salaries` (
`emp_no` INT (11) NOT NULL,
`salary` INT (11) NOT NULL,
`from_date` DATE NOT NULL,
`to_date` DATE NOT NULL,
PRIMARY KEY (`emp_no`, `from_date`)
) ;
CREATE TABLE `departments` (
`dept_no` CHAR(4) NOT NULL,
`dept_name` VARCHAR