Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
1 Contribution
Ranked #107.41K
Discussions / Questions x 1
~241 People Reached
Favorite Forums
Databases x 1
Favorite Tags
constraint x 1
foreign x 1
insert x 1
key x 1
mysql x 1
Member Avatar for Chesico
FOREIGN KEY
Share on Facebook Share on Twitter Share on LinkedIn

I'm using the statement insert into Oscar.MenuItem (idMenuItem, name, description, price, idCategory, code, sortIndex) select * from menItem; The result is: Error: Cannot add or update a child row: a foreign key constraint fails (`Oscar`.`MenuItem`, CONSTRAINT `fk_MenuItem_Category1` FOREIGN KEY (`idCategory`) REFERENCES `Category` (`idCategory`) ON DELETE NO ACTION ON UPDATE NO …

Databases constraint foreign insert key mysql
Member Avatar for pritaeas
0
1
241