John Chang wrote:

In MYSQL I'm using MYISAM. Should the 2 fields in each of the Stars & TitleGenres
table be Primary keys since they are 'tied' to other fields?
Yes, it works best if they are a primary key together (especially since the pairs are in fact unique); make sure you put the one most likely to be requested on its own as the first id in the key pair though ...

--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock



---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



  • PRI key John Chang
    • Michael T. Babcock

Reply via email to