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]
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 u
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 speed
> 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
> 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: "R
