Re: PRI key

2002-10-22 Thread Michael T. Babcock
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 mos

PRI key

2002-10-21 Thread John Chang
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? Studios (StudioName, StudioID) Genres (GenreName, GenreID) Titles (VideoTitle, Details, StudioID, GenreID, BitRateID, TitleID) Actors (F_Name, L_Name, Ac