p64 数据库表 黑马程序

CREATE TABLE dept(
id INT PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(20)
);
INSERT INTO dept(NAME) VALUES('开发部'),('市场部'),('财务部');

CREATE TABLE emp(
id INT PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(10),
gender CHAR(1), --
salary DOUBLE,
join_data DATE,
dept_id INT,
FOREIGN KEY (dept_id) REFERENCES dept(id)
);

INSERT INTO emp(NAME,gender,salary,join_data,dept_id) VALUES('孙悟空','男',8888,'2020-03-21',1);
INSERT INTO emp(NAME,gender,salary,join_data,dept_id) VALUES('猪八戒','男',8888,'2012-05-21',2);
INSERT INTO emp(NAME,gender,salary,join_data,dept_id) VALUES('唐山','男',12088,'2001-09-01',2);
INSERT INTO emp(NAME,gender,salary,join_data,dept_id) VALUES('白骨精','女',13308,'2005-07-12',3);
INSERT INTO emp(NAME,gender,salary,join_data,dept_id) VALUES('沙和尚','男',5888,'2021-08-21',1);
INSERT INTO emp(NAME,gender,salary,join_data,dept_id) VALUES('悟空','男',88288,'1020-03-21',3);

SELECT * FROM dept
SELECT * FROM emp