Answers for "Error Code: 1451. Cannot delete or update a parent row: a foreign key constraint fails (`reddit`.`token`, CONSTRAINT `FKe32ek7ixanakfqsdaokm4q9y2` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`))"

SQL
1

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
0

ERROR 1451: 1451: Cannot delete or update a parent row: a foreign key constraint fails

SET FOREIGN_KEY_CHECKS=0; -- to disable them
SET FOREIGN_KEY_CHECKS=1; -- to re-enable them
Posted by: Guest on September-20-2021

Code answers related to "Error Code: 1451. Cannot delete or update a parent row: a foreign key constraint fails (`reddit`.`token`, CONSTRAINT `FKe32ek7ixanakfqsdaokm4q9y2` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`))"

Code answers related to "SQL"

Browse Popular Code Answers by Language