Re: multiple foreign key references on one column

Quoting Roman Neuhauser <[EMAIL PROTECTED]>: > # [EMAIL PROTECTED] / 2003-09-25 > 14:59:33 +0100: > > CREATE TABLE `pheno` ( > > `id` smallint(5) unsigned NOT NULL > auto_increment, > > `relevant` enum('y','n') default NULL, > > `phenotype` varchar(50) NOT NULL default > '', > > PRIMARY KE

1 child with 2 parents

Hi, I have a table with a foreign key that references two different parent tables. I can't insert a row into this child table unless the data is in both parent tables. I don't want the data to be in both parent tables. Is there a way round? thanks Rich -- MySQL General Mailing List For list

multiple foreign key references on one column

Hi, I have three tables. One of the tables has a column that is a foreign key that references columns from the other two tables. This table is shown below. CREATE TABLE `pheno` ( `id` smallint(5) unsigned NOT NULL auto_increment, `relevant` enum('y','n') default NULL, `phenotype` varchar