MySQL error - I don't understand what it is saying

Question

Query:

INSERT INTO `job_listing_has_employer_details` (`job_listing_id`, `employer_details_id`)
VALUES (6, '5')

Error:

Cannot add or update a child row: a foreign key constraint fails (mydb.job_listing_has_employer_details, CONSTRAINT job_listing_has_employer_details_ibfk_2 FOREIGN KEY (employer_details_id) REFERENCES employer_details (id))

What does this mean? The two ID's I am inserting into the table exist.

Answer 1

It means it can't find '5' in the id column of the employer_details table. If there is a 5 in that column of that table, then maybe the data is numeric, so must be passed without quotes. If so, try:

INSERT INTO `job_listing_has_employer_details` (`job_listing_id`, `employer_details_id`) VALUES (6, 5)