Paul,
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, March 17, 2003 1:05 AM
Subject: Re: Foreign Key and default action/RESTRICT behaviour?
At 23:12 +0200 3/16/03, Heikki Tuuri wrote:
Tor,
- Original
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
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
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
At 23:12 +0200 3/16/03, Heikki Tuuri wrote:
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
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
RESTRICT is, of course, the default 'action'. ON DELETE and ON UPDATE are
later additions.
Paul DuBois wrote:
I see in the change notes that ON UPDATE was implemented in 4.0.8.
But how can ON DELETE be a later addition than RESTRICT? I was under the
impression that RESTRICT wasn't even
At 4:13 +0100 3/17/03, Andreas wrote:
RESTRICT is, of course, the default 'action'. ON DELETE and ON UPDATE are
later additions.
Paul DuBois wrote:
I see in the change notes that ON UPDATE was implemented in 4.0.8.
But how can ON DELETE be a later addition than RESTRICT? I was under the