Foreign key support for MyISAM tables is planned for version 5.0 (refering to some presentations of the UC).
Best regards Nils Valentin Tokyo/Japan 2003年 6月 17日 火曜日 03:23、Becoming Digital さんは書きました: > > so i want userTypeID in tblUsers to be a foregn key referencing the > > userTypeID col in userTypes > > both tables are myISAM > > You answered your own question. MyISAM tables don't support foreign keys. > > Edward Dudlik > Becoming Digital > www.becomingdigital.com > > > ----- Original Message ----- > From: "Rodolphe Toots" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, 16 June, 2003 04:59 > Subject: fastest DB engine > > > 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] -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
