the "FM" clearly allows the use of a FOREIGN KEY clause in the CREATE TABLE
syntax
(http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#CR
EATE_TABLE). Personally, I don't think its a stretch to assume that
mysqldump would (might || should ) maintain this definition.
After being on this list for a few months, I can see that there are a lot of
people who clearly come here with "newbie" questions who have obviously not
read the manual at all, but IMHO if all you are going to do is respond with
"RTFM" I think its better that you take a deep breath and choose not to
reply at all.
Regards,
Gary "SuperID" Huntress
=======================================================
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org
----- Original Message -----
From: "Artem Koutchine" <[EMAIL PROTECTED]>
To: "Russell Teo Wee Liang" <[EMAIL PROTECTED]>; "mysql mailing list"
<[EMAIL PROTECTED]>
Sent: Saturday, May 19, 2001 12:20 PM
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
