the Foreign Key syntax is only for compatabilty with other DB syntax. it doesn't do
anything.
check out -
http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html#Missing_Foreign_Keys
some people need to reclaim the 5 seconds of their life they use to send useless
unhelpful replies.
-----Original Message-----
From: Artem Koutchine [SMTP:[EMAIL PROTECTED]]
Sent: Saturday, May 19, 2001 12:21 PM
To: Russell Teo Wee Liang; mysql mailing list
Subject: Re: Foreign Key in creating tables
RT-F***ING-M!
No foreign keys in mysql!
----- Original Message -----
From: "Russell Teo Wee Liang" <[EMAIL PROTECTED]>
To: "mysql mailing list" <[EMAIL PROTECTED]>
Sent: Saturday, May 19, 2001 8:03 PM
Subject: Foreign Key in creating tables
Hi all,
I create a sample database using foreign keys. However, when I did a
mysqldump of the database, the creation scripts gave no indication of
the foreign keys in the first place!
I am using mysql 3.23.33 on a FreeBSD 4.0-20000626-STABLE .
Would very much appreciate some feedback or some answers to this
puzzle. I apologize if there is already some info in the archives but
I cannot seem to find it.
regards,
Russell Teo
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php