mysql语句查询: delete FROM user
WHERE uid = 7;
报错:
1451 - Cannot delete or update a parent row: a foreign key constraint fails (shop
.orders
, CONSTRAINT FKC3DF62E5AA3D9C7
FOREIGN KEY (uid
) REFERENCES user
(uid
))
*原因:
改条记录的某个字段作为innodb的另外一个表的外链。而在删除操作时会自动检查外链。
解决方法:
不检查外链,在将执行语句前加上下句:
SET FOREIGN_KEY_CHECKS = 0;
delete FROM user
WHERE uid = 7;*