• Register
0 votes
351 views

Problem :

In the MySQL I am trying to drop the table named bericht.
I tried many options however still facing the same error that my table cannot be dropped. I am facing following error message :

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

Does anybody have any clue about this error #1217?

6 5 3
7,540 points

Please log in or register to answer this question.

1 Answer

0 votes

Solution :

Following approach will help you in resolving your issue :

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

The safest solution can be to delete the tables which are dependent on bericht table before deleting bericht. I will suggest you to use the bash and the method in mentioned above to drop all the tables in your database when you do not want to or can not delete or recreate the database itself.

The above mentioned error #1217 will occur only when the other tables are having the foreign key with the table you want to delete and if you want to use the InnoDB database engine. The above solution will temporarily disables the check on restraints and after that it will re enable them. Please make sure to delete foreign key restraints and the fields in tables which are depending on your bericht table, Else you may find your database in the broken state.

Further Readings :

https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_foreign_key_checks

9 7 4
38,600 points

Related questions

1 vote
1 answer 7 views
7 views
Problem: How to figure out this in mYSQL? Error 1217 (23000): cannot delete or update a parent row: a foreign key constraint fails.
asked Apr 24 PkGuy 23.5k points
1 vote
1 answer 4 views
4 views
Problem: I keep getting this error whenever I try to use the delete statement . Error: 1451 - Cannot delete or update a parent row: a foreign key constraint fails (paymesomething.advertisers, CONSTRAINT advertisers_ibfk_1 FOREIGN KEY (advertiser_id) REFERENCES jobs (advertiser_id)) ... (`advertiser_id`) REFERENCES `jobs` (`advertiser_id`); Why am I getting this error and how can I solve this ?
asked Apr 26 Raj Tyagi 15.6k points
0 votes
1 answer 131 views
131 views
Problem : When I try to execute the below SQL command : INSERT INTO mytest_usershosts (RID,userid,hid,Usr,Pass) VALUES (NULL,1,1,"user","pass"); I am facing the below error message : ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint f ... similar cases, but I am unable to find any solution. Is there anyone who have faced the same issue and knows the fix for the issue?
asked Dec 11, 2019 alecxe 7.5k points
0 votes
1 answer 41 views
41 views
Problem: I'm getting this error when trying to delete a user from the database, I know it's doing this because the user I'm trying to delete is a foreign key in the appointments table, but I don't know how to correct it or where I have gone ... FOREIGN KEY (`doctor_id`) REFERENCES `doctors` (`id`), ADD CONSTRAINT `appointments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
asked Apr 30 muktaa 34.6k points
0 votes
1 answer 18 views
18 views
Problem: How can I fix this issue:Error 1452: cannot add or update a child row: a foreign key constraint fails .
asked Mar 15 Wafa Abu Yousef 6.1k points
0 votes
2 answers 1.7K views
1.7K views
Problem : I have created the tables in MySQL Workbench. But when I try to insert the values into the ORDRELINJE table i get below error: Error Code: 1452. Cannot add or update a child row: a foreign key constraint fails (srdjank.Ordrelinje, CONSTRAINT Ordrelinje_fk FOREIGN KEY ... (OrdreID)) I have seen many other posts on this topic but unable to fix my issue. How can I fix this issue?
asked Jan 24, 2020 jwilliam 3.9k points
0 votes
2 answers 370 views
370 views
Problem : I have created the tables in MySQL Workbench. But when want to insert values into my TBL ORDRELINJE table I face below error : Error Code: 1452. Cannot add or update a child row: a foreign key constraint fails (srdjank.TBLOrdrelinje, CONSTRAINT TBLOrdrelinje_fk FOREIGN KEY ... do the research on this topic, but no luck. Am I doing any mistake or someone have any idea about what can I do?
asked Dec 21, 2019 alecxe 7.5k points
0 votes
1 answer 4 views
4 views
Problem: table 1 +----------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------------- ... /table2`, CONSTRAINT `table2_ibfk_1` FOREIGN KEY (`UserID`) REFERENCES `table1` (`UserID`)) What have I done wrong? I read http://www.w3schools.com/Sql/sql_foreignkey.asp and I don't see what's wrong.
asked Apr 26 anika11 32.2k points
0 votes
1 answer 4 views
4 views
Problem: Mysql error 1452 - Cannot add or update a child row: a foreign key constraint fails.How to resolve this error?
asked Apr 21 Humaira ahmed 50.7k points
0 votes
1 answer 3 views
3 views
Problem: Error:com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`myapp/table2`, CONSTRAINT `table2_ibfk_1` FOREIGN KEY (`UserID`) REFERENCES `table1` (`UserID`)) What have I done wrong? I read http://www.w3schools.com/Sql/sql_foreignkey.asp and I don't see what's wrong.
asked May 4 sumaiya simi 43.9k points