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

by

The simple way would be to disable the foreign key check; make the changes then re-enable foreign key check.

SET FOREIGN_KEY_CHECKS=0; -- to disable them
SET FOREIGN_KEY_CHECKS=1; -- to re-enable them

More Related Contents:

  1. i have an error which i dont understand. can you help me? [closed]
  2. In SQL Server how to get the count of child if both parent and child are available [closed]
  3. Rank function in MySQL
  4. MySQL select 10 random rows from 600K rows fast
  5. Get a list of dates between two dates
  6. Count the number of occurrences of a string in a VARCHAR field?
  7. Find nearest latitude/longitude with an SQL query
  8. Simulate lag function in MySQL
  9. MySQL query String contains
  10. Best data type for storing currency values in a MySQL database
  11. Datetime equal or greater than today in MySQL
  12. How to get the next auto-increment id in mysql
  13. MySQL dynamic-pivot
  14. Entity-Attribute-Value Table Design
  15. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  16. MySQL Workbench: How to keep the connection alive
  17. Filter by COUNT(*)?
  18. Deleting duplicate rows from a table
  19. MySQL concatenation operator
  20. SQL Group By with an Order By
  21. How create json format with group-concat mysql?
  22. MySQL LIKE query with underscore
  23. MySql – Way to update portion of a string?
  24. Using reserved words in column names
  25. MySQL INNER JOIN select only one row from second table
  26. What is the difference between SQL and MySQL? [closed]
  27. how to use a like with a join in sql?
  28. SQL (MySQL) vs NoSQL (CouchDB) [closed]
  29. How to convert a varchar column type to date type without losing the dates
  30. MySQL Multiple Joins in one query?

Leave a Comment