1217 cannot delete or update a parent row a foreign key constraint fails

You’re trying to delete a table and it returns the error 1217 cannot delete or update a parent row a foreign key constraint fails. Here is a solution.

Why you’re having this error:

The error code is self-explaining, SQL cannot make modifications to the parent table or the table that depends on the table you’re trying to delete. In other words, there are records from another table or tables that has foreign key constraints to the table you are trying to delete and you are using the InnoDB database engine.

In the solution provided here, I begin by turning off foreign key checks by setting it to 0, then proceed to delete the table and lastly turn foreign_key_checks back on by setting it to 1; That is a quick way to solve it but not the recommended way to solve it.

The solution to 1217 cannot delete or update a parent row

SET FOREIGN_KEY_CHECKS=0; DROP TABLE bericht; SET FOREIGN_KEY_CHECKS=1;

As earlier stated, there is a better way to handle this error other than turning off foreign_key_checks. A better solution is to manually delete all records on the other table that references a record on the table you’re trying to delete.

All you need to know about Loans | Best Loans offers android BBN 2021 Best Laravel Guide | Code Best vue.js tutorials || Latest Practical Vue Js Tutorials Covid-19 Cross River News Update | Novel Coronavirus Dating Dell earn insurance iphones istagram JAMB laptops Laragon Laravel Tutorials Simple to Advance Latest Amazon Technologies || List of all Amazon Technologies Latest Educational News Latest Job Opportunities News | All Recruitment News latest news from Google | Browse Google latest info Latest Technology News || Trending Technologies Latest Waec News and Info neco Netflix Nigeria Civil Defence Nigeria Customs Service Nigeria Examinations News scholarships syllabus Trailers

Leave a Comment

%d bloggers like this: