mysql1452 错误代码_MYSQL报1452错误

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');