RalphS007
asked on
Error Message
MySQL said: Documentation
#1452 - Cannot add or update a child row: a foreign key constraint fails (`galaxy_cms`.<result 2 when explaining filename '#sql-13d8_5a'>, CONSTRAINT `#sql-13d8_5a_ibfk_1` FOREIGN KEY (`skill_category`) REFERENCES `admin_skills_category` (`skills_category`))
#1452 - Cannot add or update a child row: a foreign key constraint fails (`galaxy_cms`.<result 2 when explaining filename '#sql-13d8_5a'>, CONSTRAINT `#sql-13d8_5a_ibfk_1` FOREIGN KEY (`skill_category`) REFERENCES `admin_skills_category` (`skills_category`))
ALTER TABLE `admin_skills` ADD FOREIGN KEY ( `skill_category` ) REFERENCES `galaxy_cms`.`admin_skills_category` (
`skills_category`
) ON DELETE RESTRICT ON UPDATE RESTRICT ;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I meant the value is not available on the skills_category in admin_akills_category table