List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 27 2002 4:41pm
Subject:Re: foreign key support??
View as plain text  
At 17:29 +0200 9/27/02, Remco Barendse wrote:
>Hi!
>
>According to the website MySQL 4.0.x supports "foreign key constraints".
>
>For version 4.1 "foreign key integrity rules" are planned.
>
>What is the difference between these 2? On previous versions of MySQL it
>was possible to create foreign keys but changed data was not replicated to
>other tables.
>
>I need foreign key support for MySQL as is available in PostgreSQL.
>
>Any input greatly appreciated!
>
>Best regards,
>Remco Barendse

InnoDB tables support foreign key definitions as of 3.23.44.  This means
you cannot insert records into a child table unless the key value is listed
in the parent table.

MySQL 3.23.50 adds support for ON DELETE CASCADE and ON DELETE SET NULL.
This causes deletion of records in the parent table to affect the child
table.

ON UPDATE is not supported.
Thread
foreign key support??Remco Barendse27 Sep
  • re: foreign key support??Egor Egorov27 Sep
  • Re: foreign key support??Paul DuBois27 Sep
Re: foreign key support??Scott Pippin27 Sep