MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Heikki Tuuri Date:March 16 2003 9:12pm
Subject:Re: Foreign Key and default action/RESTRICT behaviour?
View as plain text  
Tor,

----- Original Message -----
From: ""Tor R. Skoglund (NextG)"" <trskog@stripped>
Newsgroups: mailing.database.mysql
Sent: Sunday, March 16, 2003 10:11 PM
Subject: Foreign Key and default action/RESTRICT behaviour?


> 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?

RESTRICT is, of course, the default 'action'. ON DELETE and ON UPDATE are
later additions.

...

> Best regards,
> Tor Rune Skoglund
> trskog@stripped

Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-4.0 from http://www.mysql.com

sql query



Thread
Foreign Key and default action/RESTRICT behaviour?NextG)16 Mar
  • Re: Foreign Key and default action/RESTRICT behaviour?Paul DuBois16 Mar
    • Re: Foreign Key and default action/RESTRICT behaviour?Paul DuBois17 Mar
Re: Foreign Key and default action/RESTRICT behaviour?Heikki Tuuri16 Mar
  • Re: Foreign Key and default action/RESTRICT behaviour?Paul DuBois17 Mar
    • Re: Foreign Key and default action/RESTRICT behaviour?Andreas17 Mar
      • Re: Foreign Key and default action/RESTRICT behaviour?Paul DuBois17 Mar
Re: Foreign Key and default action/RESTRICT behaviour?Heikki Tuuri17 Mar