Re: help need with relations
In order to create a relation between tables you'll want to put the primary key from one table, PARENT (for example), into the child table, CHILD, as part of its composite key.
I have found phpMyAdmin less than ideal for viewing or creating relations but maybe I just don't know the best way. I suggest you use the InnoDB table type so that your foreign key constraints are enforced.
Subject
Written By
Posted
Re: help need with relations
May 26, 2005 07:59PM
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.