MySQL Forums
Forum List  »  MyISAM

Re: Novice / Intermediate user seeks help in structuring data / tables
Posted by: mark turner
Date: January 27, 2006 09:03AM

quick question:

with a MyIsam database, to create relationships between tables, is it just a case to include a pk of one table as an index within another table?

for example,

TableKennel:

Dogid (pk)
breedid (index)
sexid (index)

TableDogBreed:

breedid (pk)
breedname

TableDogSex:

sexid (pk)
malefemale


I usually create tables through MyPhp admin, but my current clients host does not offer InnoDB as an option.

Options: ReplyQuote




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.