今天用Hibernate建立外键的时候发现没有建立
但是创建了这个字段
情景：
user表有一字段role，role是role表id字段的外键
原因：
user表中已经有记录了，而且有的记录role这个字段在role表没有对应的id，所以就不能创建外键
解决方案：
先手动修改user.role字段，修改成已经在role表中存在的id值
相关文章
- java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails
- insert时报Cannot add or update a child row: a foreign key constraint fails (`yanchangzichan`.`productstatusrecord`, CONSTRAINT `p_cu` FOREIGN KEY (`cid`) REFERENCES `customer` (`cid`))错误
- admin添加用户时报错：(1452, 'Cannot add or update a child row: a foreign key constraint fails (`mxonline`.`django_admin_l
- MySql数据库插入或更新报错：Cannot add or update a child row: a foreign key constraint fails
- Error 'Cannot add or update a child row: a foreign key constraint fails故障解决
- IntegrityError at /admin/users/userprofile/add/ (1452, 'Cannot add or update a child row: a foreign key constraint fails (`mxonline`.`django_admin_log`, CONSTRAINT `django_admin_log_user_id_c564eba6_
- Mysql数据库报错：Cannot add or update a child row: a foreign key constraint fails（添加多对多关系）
- ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint......
- 关闭外键检查 ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails
- MySQL设置外键报错 #1452 - Cannot add or update a child row: a foreign key constraint fails 解决方法