Let me quote from that link:
"The FOREIGN KEY, CHECK, and REFERENCES clauses don't actually do
anything. The syntax for them is provided only for compatibility, to
make it easier to port code from other SQL servers and to run
applications that create tables with references. See section 5.4
Functionality Missing from MySQL."
I repeat: "don't actually do anything"
That means not a single thing, right?
----- Original Message -----
From: "Russell Teo Wee Liang" <[EMAIL PROTECTED]>
To: "Artem Koutchine" <[EMAIL PROTECTED]>; "Nisha Raju"
<[EMAIL PROTECTED]>; "mysql" <[EMAIL PROTECTED]>
Sent: Saturday, May 19, 2001 9:48 PM
Subject: Re: Foreign Key in creating tables
> seems like he hasn't read the question properly, check out this
answer that
> I got, which is what I needed:
>
> 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.h
tml#CR
> EATE_TABLE).
> Personally, I don't think its a stretch to assume that mysqldump
would
> (might || should ) maintain this definition.
>
> So is he so certain that Mysqldump doesn't maintain this definition
before
> chastising someone with his harsh words and aloof attitude?
>
> ----- Original Message -----
> From: "Artem Koutchine" <[EMAIL PROTECTED]>
> To: "Nisha Raju" <[EMAIL PROTECTED]>; "mysql" <[EMAIL PROTECTED]>
> Sent: Sunday, May 20, 2001 1:31 AM
> Subject: Re: Foreign Key in creating tables
>
>
> > My appoligies. I probably was pissed off by the bunch of
> > newbie questions i got today. I'll try to not replay next time I
> > see something like that.
> >
> > Anyhow, i wonder, how hard could it be to open your
> > favorite viewer/editor, load the manual in txt format in it
> > and look for 'foreign' keyword? Or just grep the manual
> > so you find all possible information for the subject in
> > question.
> >
> > PS: Replies like mine are not waste of time. They are
> > psychological burn-out. They make you feel better:)
> >
> > ----- Original Message -----
> > From: "Nisha Raju" <[EMAIL PROTECTED]>
> > To: "Artem Koutchine" <[EMAIL PROTECTED]>; "mysql"
> > <[EMAIL PROTECTED]>
> > Sent: Saturday, May 19, 2001 9:14 PM
> > Subject: Re: Foreign Key in creating tables
> >
> >
> > >
> > > I wish we maintained some ethics in writing. Knowledge shouldn't
> > make us
> > > arrogant.
> > >
> > >
> > > > RT-F***ING-M!
> > > >
> > > > No foreign keys in mysql!
> > >
> > >
> > >
> >
> --------------------------------------------------------------------
> > -
> > > 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
> >
>
>
> --------------------------------------------------------------------
-
> 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
