> second, i have followed some discussions here about > foreign keys but i still have not managed to create > foreign keys > > so i want userTypeID in tblUsers to be a foregn key > referencing the userTypeID col in userTypes . . . > what is wrong?
Nothing is wrong. Sounds like a perfect fine use of foreign keys. Why do you think something is wrong? --John On Monday 16 June 2003 04:59 am, Rodolphe Toots wrote: > hi all! > > i am currently working on a community projekt > the DB is a mySQL DB but i am not sure which engine to > use i know that innoDB supports foreign keys which i > really want i order to keep the data consistent since > there will be a lots of insert, delete and update > activity with forums and guestbooks and new users and so > on and i know i can have different table types in the > same DB > > but from what i've learned myISAM is the fastest > is this true > > second, i have followed some discussions here about > foreign keys but i still have nog managed to create > foreign keys > > i have a table users and another userTypes where > > tblUsers have columns > userID, usertypeID, username, password... > > and tblUserType > userTypeID, userType > > so i want userTypeID in tblUsers to be a foregn key > referencing the userTypeID col in userTypes > both tables are myISAM > userID is indexed and primary key in tblUsers > userTypeID is indexed and primary key in tblUserType > userTypeID in both tables are int(10) > > what is wrong? > my OS is win XP pro and i have mySQL 4.1 (not really sure > exact version since i cannot reach the DB from where i am > right now) > > thanks in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]