josephman1988 Posted September 2, 2008 Share Posted September 2, 2008 Hey guys, I believe I've been related tables wrongly. So i'm now doing them the 'correct way'. Anyway, I have a 'games Table': games: gId (Auto_Increment + Primary Key) gName iTitle included: iId (Auto Increment + Primary Key) iTitle Now is this the correct way to 'relate' them? Quote Link to comment Share on other sites More sharing options...
cooldude832 Posted September 2, 2008 Share Posted September 2, 2008 u relate on primary keys/foreign keys so use iID (u can do full text but then the relationship sorta become useless) But yeah that's the basic idea. Quote Link to comment Share on other sites More sharing options...
fenway Posted September 2, 2008 Share Posted September 2, 2008 But yeah that's the basic idea. That's the "idea"... but to use the non-PK is completely incorrect. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.