MySQL设置外键约束是否有效

设置为失效：SET FOREIGN_KEY_CHECKS = 0;
设置有有效：SET FOREIGN_KEY_CHECKS = 1;
解决错误号：1452
Cannot add or update a child row: a foreign key constraint fails (audit_ssh.audit_menu, CONSTRAINT FK3s23crmhqgol1wwvijewa73pk FOREIGN KEY (pid) REFERENCES audit_menu (menu_id))

posted @ 2022-02-10 13:14  JohnYu35  阅读(113)  评论(0)    收藏  举报