当使用外键而外键没有填入数据库就会报错
解决方案：执行下面sql语句
SET FOREIGN_KEY_CHECKS=0;
解决完成后改回来
SET FOREIGN_KEY_CHECKS=1;
相关文章
- 02-06admin添加用户时报错：(1452, 'Cannot add or update a child row: a foreign key constraint fails (`mxonline`.`django_admin_l
- 02-06Error Code: 1452 Cannot add or update a child row: a foreign key constraint fails
- 02-06ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint......
- 02-06[ERR] 1217 - Cannot delete or update a parent row: a foreign key constraint
- 02-06外键添加失败：java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails
- 02-061452, 'Cannot add or update a child row: a foreign key constraint fails
- 02-06workbench添加不了外键Cannot add or update a child row: a foreign key constraint fails原因
- 02-06报错：Cannot add or update a child row: a foreign key constraint fails
- 02-06ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails ()
- 02-06关于mysql中[Err] 1451 -Cannot delete or update a parent row: a foreign key constraint fails