Answers for "#1451 - cannot delete or update a parent row: a foreign key constraint fails (`kuiz_maths`.`pilihan`, constraint `pilihan_ibfk_1` foreign key (`idsoalan`) references `soalan` (`idsoalan`))"

SQL

error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails

SET FOREIGN_KEY_CHECKS = 0; -- to disable FK checks (ex: for delete purpose)
SET FOREIGN_KEY_CHECKS = 1; -- to re-enable FK checks

Posted by: Guest on March-21-2021

1 - Cannot delete or update a parent row: a foreign key constraint fails

SET FOREIGN_KEY_CHECKS=0; -- to disable them
DELETE FROM `jobs` WHERE `job_id` = 1 LIMIT 1 
SET FOREIGN_KEY_CHECKS=1; -- to re-enable them

Posted by: Guest on October-22-2021

Source

Code answers related to "#1451 - cannot delete or update a parent row: a foreign key constraint fails (`kuiz_maths`.`pilihan`, constraint `pilihan_ibfk_1` foreign key (`idsoalan`) references `soalan` (`idsoalan`))"

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java