At 06:51 PM 9/20/1999 , M wrote:
>Hi,
>
>I am currently using MySQL 3.21.33b and cannot get the FOREIGN KEY syntax to
>work. I have read the manual thoroughly and have also searched the web for
>examples, which I have found none (not surprised as MySQL does not really
>support foreign keys). I have tried a variety of ways to make it work, but
>always get an error. What am I doing wrong, could someone give me a small
>example please?
>
Look at
http://www.mysql.com/Manual_chapter/manual_Compatibility.html#Missing_Foreig
n_Keys
...mySQL does not support foreign keys; it will accept 'foreign key' as
part of a table definition for compatibility, but it ignores it.
-steve
+-------------------- "He's dead, Jim" - Bones McCoy --------------------+
| Steve Edberg University of California, Davis |
| sbedberg@stripped http://aesric.ucdavis.edu/ |
| (530)754-9127 |
+---------------------- DeForest Kelley 1920-1999 -----------------------+
