Foreign Key problems
Posted by:
Paul Reiser
Date: September 12, 2014 10:46PM
Hello, I am new at using MySQL. I am using Innodb, and Workbench, and I am having foreign key problems. I am using Workbench, trying to make a simple genealogy database, with and PEOPLE table for people, PARENTS table for parent pairs, and SOURCES table for sources. I use this command:
INSERT INTO `mydb`.`PARENTS` (`PARE`, `SOUR`, `PARE1`, `PARE2`) VALUES ('McDowell-Mitchell', 'Source 1', 'Matthew McDowell', 'Mariah Mitchell');
and get this error:
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`mydb`.`parents`, CONSTRAINT `PARE1` FOREIGN KEY (`PARE1`) REFERENCES `PEOPLE` (`INDI`) ON DELETE NO ACTION ON UPDATE NO ACTION)
I'm using the first and second columns on the PEOPLE table (INDI and SOUR) as a unique index, same for PARENTS (PARE and SOUR) and the foreign keys reference those columns, in the proper order (as shown by Workbench)
Maybe this is not enough information, but I will provide more if needed. Thanks for any help.
Paul Reiser
Subject
Views
Written By
Posted
Foreign Key problems
1576
September 12, 2014 10:46PM
824
September 13, 2014 09:18PM
858
September 14, 2014 02:39AM
863
September 14, 2014 01:15PM
1127
September 14, 2014 07:40PM
888
September 14, 2014 09:37PM
886
September 14, 2014 11:07PM
938
September 15, 2014 07:26AM
1065
September 15, 2014 11:08AM
878
September 15, 2014 03:16PM