Re: Primary and foreign key
Vanessa, I'm not sure it it will solve the problemn entirely, but what definitely prevents the foreign key from being created is that `contacts` and `SOCIETES` are backed by the MyISAM storage engine.
MySQL, up till now that is, only supports foreign keys for tables backed by the InnoDB storage engine. And, *both* referenced an referencing tables need to be InnoDB.
You should decide what to do now, because maybe there's some special reason for using the MyISAM engine for those two tables.
Good luck!
Subject
Views
Written By
Posted
11674
July 15, 2005 11:36AM
5149
July 15, 2005 04:12PM
7836
July 16, 2005 03:22AM
Re: Primary and foreign key
4375
July 16, 2005 04:41AM
3935
July 16, 2005 06:45AM
3975
July 25, 2005 06:04PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.