From: Date: March 17 2003 12:32am
Subject: Re: Foreign Key and default action/RESTRICT behaviour?
List-Archive: http://lists.mysql.com/mysql/134860
Message-Id: <p05200f2bba9ab94922ce@[192.168.0.33]>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii" ; format="flowed"

At 14:29 -0600 3/16/03, Paul DuBois wrote:
>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.

Heikki's clarified that RESTRICT is the default, which means it
must be implemented.

Obviously I don't know anything.  Don't listen to me.

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