Tor,
----- Original Message -----
From: ""Tor R. Skoglund (NextG)"" <[EMAIL PROTECTED]>
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
> [EMAIL PROTECTED]
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
---------------------------------------------------------------------
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
