ERROR 1452: Cannot add or update a child row: a foreign key constraint fails

by

Taken from Using FOREIGN KEY Constraints

Foreign key relationships involve a parent table that holds the
central data values, and a child table with identical values pointing
back to its parent. The FOREIGN KEY clause is specified in the child
table.

It will reject any INSERT or UPDATE operation that attempts to create
a foreign key value in a child table if there is no a matching
candidate key value in the parent table.

So your error Error Code: 1452. Cannot add or update a child row: a foreign key constraint fails essentially means that, you are trying to add a row to your Ordrelinje table for which no matching row (OrderID) is present in Ordre table.

You must first insert the row to your Ordre table.

More Related Contents:

  1. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '0
  2. how to delete data from table A besides the customer service and director data in table B?
  3. MySQL/MariaDB – order by inside subquery
  4. Cast int to varchar
  5. MySQL – SELECT * INTO OUTFILE LOCAL ?
  6. In SQL Server how to get the count of child if both parent and child are available [closed]
  7. Delete the entire content of all table in a Database [closed]
  8. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  9. Get a list of dates between two dates
  10. Calculate a running total in MySQL
  11. MySQL – How to unpivot columns to rows?
  12. MySQL SELECT only not null values
  13. Detect if value is number in MySQL
  14. Difference between two dates in MySQL
  15. How do I create a sequence in MySQL?
  16. MySQL search and replace some text in a field
  17. How to get the next auto-increment id in mysql
  18. MySQL dynamic-pivot
  19. Can I reuse a calculated field in a SELECT query?
  20. Group mysql query by 15 min intervals
  21. Deleting duplicate rows from a table
  22. Using Count to find the number of occurrences
  23. Is there any reason to worry about the column order in a table?
  24. Checking a table for time overlap?
  25. MySQL INSERT INTO … VALUES and SELECT
  26. MySQL LIKE query with underscore
  27. MYSQL select DISTINCT values in two columns
  28. Compare only day and month with date field in mysql
  29. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  30. SQL query with avg and group by

Leave a Comment