Why can’t this entry be added because of Foreign Key error?

by

When you try to insert this record:

INSERT INTO ROUTE VALUES ('7418','66','200','313');

You are assuming that there is a value in DELIVERY with a VEHICLE_VEH_ID value of '200' and a DELIVERY_DRIVER_DR_ID value of '313'. There error is telling you that there is no such record in that table.

A foreign key constraint means that the column(s) with that constraint is/are constrained to only point to valid records in the foreign table. (In this case DELIVERY.) Such a record must exist in that table before you can insert a dependent record in this table.

More Related Contents:

  1. Search text in fields in every table of a MySQL database
  2. Which MySQL data type to use for storing boolean values
  3. MySQL join with where clause
  4. Implementing Comments and Likes in database
  5. How to check if mysql database exists
  6. SELECT * FROM multiple tables. MySQL
  7. What is the MySQL JDBC driver connection string?
  8. How to get the difference between two timestamps in seconds
  9. INSERT INTO…SELECT for all MySQL columns
  10. How to export SQL Server database to MySQL? [duplicate]
  11. MySQL: Select top n max values?
  12. MySQL search in comma list [duplicate]
  13. What is MySQL’s default ON DELETE behavior?
  14. MySQL – How to search for exact word match using LIKE?
  15. Fetching UTF-8 text from MySQL in R returns “????”
  16. MySQL error 1022 when creating table
  17. MySQL – Persistent connection vs connection pooling
  18. How do I setup ASP.NET MVC 2 with MySQL?
  19. mysql DECLARE WHILE outside stored procedure how?
  20. SELECT query return 1 row from each group
  21. MySql Single Table, Select last 7 days and include empty rows
  22. ERROR: Loading local data is disabled – this must be enabled on both the client and server sides
  23. mysql SQL: specific item to be first and then to sort the rest of the items
  24. Why doesn’t MySQL’s MyISAM engine support Foreign keys?
  25. SELECT INTO Variable in MySQL DECLARE causes syntax error?
  26. Where does MySQL store database files on Windows and what are the names of the files?
  27. RMySQL dbWriteTable with field.types
  28. Update multiple rows with multiple ‘where’ clauses for each individual row
  29. WHERE datetime older than some time (eg. 15 minutes)
  30. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?

Leave a Comment