mysql - 将值插入到递归表中？

Question

嗯，我的递归表还有另一个问题。

这是表定义:

create table seguridad (
    cod_emple int(6) ZEROFILL NOT NULL,
    cod_jefe int(6) ZEROFILL DEFAULT NULL,
    TIP int(5) NOT NULL,
    division_seguridad varchar(40) NOT NULL,
    PRIMARY KEY (cod_emple),
    INDEX (cod_jefe),
    FOREIGN KEY (cod_jefe) REFERENCES seguridad (cod_emple) ON DELETE RESTRICT ON UPDATE CASCADE,
    FOREIGN KEY (cod_emple) REFERENCES empleados (cod_emple) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=INNODB;

但是当我尝试插入这个时:

insert into seguridad values (002237, 2213, 28465, 'VIGILANTE');

或

insert into empleados values (002889, NULL, 26675, 'GUARDIA CIVIL');

我第一次遇到这个错误:

#1452. Cannot add or update a child row: a foreign key constraint fails (`prision_arenales`.`seguridad`, CONSTRAINT `seguridad_ibfk_1` FOREIGN KEY (`cod_jefe`) REFERENCES `seguridad` (`cod_emple`) ON UPDATE CASCADE)

这是第二个:

#1136. Column count doesn't match value count at row 1

我做错了什么？我从 https://planet.mysql.com/entry/?id=599259 做了同样的事情

Answer 1

第一个表示 seguridad (cod_empl) 中不包含值 002237

第二个表示 empleados 没有 5 列