Remco,
Friday, September 27, 2002, 6:29:28 PM, you wrote:

RB> According to the website MySQL 4.0.x supports "foreign key constraints".

RB> For version 4.1 "foreign key integrity rules" are planned.

RB> What is the difference between these 2? On previous versions of MySQL it 
RB> was possible to create foreign keys but changed data was not replicated to 
RB> other tables.

RB> I need foreign key support for MySQL as is available in PostgreSQL.

Foreign key constraints currently is supported only on the InnoDB tables. Some
features for foreign key are still in the TODO list. Foreign key on
MyISAM tables will come in the 4.1



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com




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

Reply via email to