Answers for "SQL Error [1217] [23000]: Cannot delete or update a parent row: a foreign key constraint fails Cannot delete or update a parent row: a foreign key constraint fails Cannot delete or update a parent row: a foreign key constraint fails"

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

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

ALTER TABLE "appointments" DROP FOREIGN KEY "appointments_user_id_foreign";

ALTER TABLE "appointments" ADD CONSTRAINT "appointments_user_id_foreign" FOREIGN KEY ("user_id") REFERENCES "users" ("id") ON DELETE CASCADE;

Posted by: Guest on March-09-2021

Source

Code answers related to "SQL Error [1217] [23000]: Cannot delete or update a parent row: a foreign key constraint fails Cannot delete or update a parent row: a foreign key constraint fails Cannot delete or update a parent row: a foreign key constraint fails"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

Answers for "SQL Error [1217] [23000]: Cannot delete or update a parent row: a foreign key constraint fails Cannot delete or update a parent row: a foreign key constraint fails Cannot delete or update a parent row: a foreign key constraint fails"

Code answers related to "SQL Error [1217] [23000]: Cannot delete or update a parent row: a foreign key constraint fails Cannot delete or update a parent row: a foreign key constraint fails Cannot delete or update a parent row: a foreign key constraint fails"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us