#1451 - Cannot delete or update a parent row: a foreign key constraint fails (`shop`.`orders`, CONST

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;*