drop table if exists t2;
drop table if exists t3;
create table t2
(
s1 int, primary key (s1)
)
engine=innodb;
create table t3
(
s1 int, key (s1),
foreign key (s1) references t2 (s1)
)
engine=innodb;
delete from t2;
delete from t3;
insert into t3 values (5);
/*
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails
(`db5`.`t3`, CONSTRAINT `t3_ibfk_1` FOREIGN KEY (`s1`) REFERENCES `t2` (`s1
`))
*/
我开始要创建一个主键表,以及一个外键表。我们使用的是InnoDB,因此外键关联检查是打
开的。然后当我向外键表中插入非主键表中的值时,动作将会失败。