How do I unscribe from this list?
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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:
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
InnoDB is very fast. In theory, I guess MyISAM is considered faster
(that may not even be true these days). We're talking about fine hairs
here and I haven't heard anybody complain about InnoDB-specific speed
problems. Anyway, if you're using Windows, you're must not be too
concerned about
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:23Becoming Digital :
so i want userTypeID in tblUsers to be a foregn key referencing the
userTypeID col in userTypes
both