mysql - Foreign Key Constraints -
error 1452: 1452: cannot add together or update kid row: foreign key constraint fails (`harris`.`manager`, constraint `fk_employee_has_project_project1` foreign key (`project_project_id`) references `project` (`project_id`) on delete no action on update no action) sql statement: insert `harris`.`manager` (`employee_employee_id`, `project_project_id`) values ('employee_employee_id', 'project_project_id')
no matter foreign key utilize won't work. reason adds "1" end ie: project_project when should project_id , employye_num
mysql
No comments:
Post a Comment