From: Date: March 16 2003 9:29pm
Subject: Re: Foreign Key and default action/RESTRICT behaviour?
List-Archive: http://lists.mysql.com/mysql/134852
Message-Id: <p05200f29ba9a8ee3cf27@[192.168.0.33]>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii" ; format="flowed"

At 19:21 +0100 3/16/03, Tor R. Skoglund (NextG) wrote:
>Hi List, regarding the foreign key definitions:
>
>[CONSTRAINT symbol] FOREIGN KEY (index_col_name, ...)
>                   REFERENCES table_name (index_col_name, ...)
>                   [ON DELETE {CASCADE | SET NULL | NO ACTION
>                               | RESTRICT}]
>                   [ON UPDATE {CASCADE | SET NULL | NO ACTION
>                               | RESTRICT}]
>
>Is there a default action for ON DELETE and ON UPDATE if no action
>is specified in the database definition?

The NO ACTION action seems to cover this. :-)

>
>I presume RESTRICT makes it impossible to delete a record from
>the parent table if there are any references from a child record to
>the parent for that key?

It's unimplemented.

>
>The MySQL documentation on the web does not seem to say
>anything about this...
>
>
>Best regards,
>Tor Rune Skoglund
>trskog@stripped
>
>sql query



-- 
Paul DuBois
http://www.kitebird.com/
sql, query