MySQL Forums
Forum List  »  Newbie

Re: help need with relations
Posted by: Conor Linberg
Date: May 26, 2005 07:59PM

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.

Options: ReplyQuote


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.