Take a look at:
http://www.mysql.com/doc/M/i/Missing_Foreign_Keys.html
Basically, MySQL does not support foreign keys. Therefore, referrential data
integrity (RDI) is also not available.
Good Luck,
Dennis
**********************************************
Beridney Computer Services
http://www.beridney.com
----- Original Message -----
From: "Jeff Tanner" <[EMAIL PROTECTED]>
To: "Mysql (E-mail)" <[EMAIL PROTECTED]>
Sent: Tuesday, September 11, 2001 9:13 AM
Subject: FOREIGN KEY ... ON DELETE CASCADE
> Is FOREIGN KEY ... ON DELETE CASCADE operational in mysql?
>
> If so, I am not observing such. Here is how I am using it:
>
>
> CREATE TABLE scheduled_task_list (
> schedule_id CHAR(28) NOT NULL,
>
> /* keys */
> PRIMARY KEY (schedule_id)
> );
>
> CREATE TABLE scheduled_task_instances (
> task_instance_id CHAR(28) NOT NULL,
>
> schedule_id CHAR(28) NOT NULL,
>
>
> /* keys */
> PRIMARY KEY (task_instance_id),
>
> /* constraints */
> FOREIGN KEY (schedule_id)
> REFERENCES scheduled_task_list (schedule_id)
> ON DELETE CASCADE
> );
>
> ---------------------------------------------------------------------
> 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
>
>
---------------------------------------------------------------------
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
