I have previously always built databases by hand, but recently discovered the MySQL Workbench, which is a handy little tool.
Unfortunately, it is adding foreign key constraints to my database relationships, which is something I have never used before.
I am getting this error on an INSERT command:
#1452 - Cannot add or update a child row: a foreign key constraint fails (`bugreport`.`projects_has_workers`, CONSTRAINT `fk_projects_has_workers_workers1` FOREIGN KEY (`workers_workers_id`) REFERENCES `workers` (`workers_id`) ON DELETE NO ACTION ON UPDATE NO ACTION)
Can someone explain to me what this means? I understand that the database is upset that a foreign key is reference, and it probably thinks that something doesn't exist where it should, but I just don't quite understand it.