Tuesday, 15 September 2015

mysql - Foreign Key Constraints -



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