yii null 外键
我有这样的db结构http://pikucha.ru/icFsc(我无法添加图片这里)
I have such structure of db http://pikucha.ru/icFsc (I can't add pictures here)
有些地址我没有metro(其他表也有同样的问题，例如user"可能没有地址，但user"表中有约束)
Some addresses my not have a metro (other tables have the same problem, for example "user" may not have an address, but there is constraint in "user" table)
如果我在mysql中添加一条记录就可以了.如果我使用 yii 做同样的事情，我会得到一个错误
If I add a record in mysql it's ok. If I do the same thing using yii I get an error
无法添加或更新子行:外键约束失败 (address, CONSTRAINT fk_Address_Area1 FOREIGN KEY (area_id)参考 area (id) ON UPDATE NO ACTION)
Cannot add or update a child row: a foreign key constraint fails (address, CONSTRAINT fk_Address_Area1 FOREIGN KEY (area_id) REFERENCES area (id) ON UPDATE NO ACTION)
那么，问题出在哪里?
推荐答案
这个错误可能是由于下面提到的一些原因造成的
1. fk 和 pk 的数据类型可能不同.
2. fk 和 pk 的大小可能不一样
3. 类型可能不同，如无符号、二进制、无符号二进制和空
4. 你在city中输入的值没有出现在area table中
This error can occur due to some reasons as mentioned below
1. Data Types may not be the same for fk and pk.
2. Size may not be the same of fk and pk
3. type may be different like unsigned, binary,unsigned binary and null
4. The value you are trying to put in city does not occur in area table
相关文章