扫码加入数据分析学习群

create table department(
deptno int primary key auto_increment,
dname varchar(15),
loc varchar(10));

create table employee(
empno int primary key auto_increment,
ename varchar(15) unique,
job varchar(10) not null default "-",
mgr int,
hiredate date,
sal float default 0,
comm float,
deptno int,
foreign key employee(deptno) references department(deptno));

建立了两张表department和employee，在给表employee导入数据时，报如下错误：

原因在于，本题表employee的deptno设置了外键约束，所以，必须表department需要先有值，且employee对应的deptno取值来自表department的deptno.

解决办法：给表department导入数据就好。
insert into department values 
(10,'accounting','new york'),
(20,'research','dallas'),
(30,'sales','chicago'),
(40,'operations','boston');