CREATE TABLE dept11(

id int primary key auto_increment,

dep_name varchar(20),

addr varchar(20)

);

CREATE TABLE emp11(

id int primary key auto_increment,

name varchar(20),

age int,

dep_id int,

-- 添加外鍵dep_id,關(guān)聯(lián)dept表的id主鍵

CONSTRAINT fk_emp11_dept11 FOREIGN KEY(dep_id) REFERENCES dept11(id)

);--fk是隨意字符串

INSERT INTO dept11(dep_name,addr) values('研發(fā)部','廣州'),('銷售部','深圳');

INSERT INTO emp11(NAME,age,dep_id)values

('張三',20,1),

('李四',20,1),

('王五',20,1),

('趙六',20,2),

('孫七',22,2),

('周八',18,2);

select * from emp11;

select * from dept11;