Hi! The brand-new source prerelease 3.23.50b-pre which you can download from http://www.innodb.com supports ON DELETE CASCADE and ON DELETE SET NULL. But does not support ON UPDATE CASCADE. Typically a foreign key refers to the primary key of another table, and it is not that common a primary key is updated. Thus I chose to write ON DELETE CASCADE first.
Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com ----- Original Message ----- From: "bin cai" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, April 17, 2002 9:13 PM Subject: foreign key on update cascade in mysql doesn't work > Hello, > I create innoDB tables database in mysql3.23.49. > i create foreign key constraints(On UPdate cascade) in > one table. but it seems doesn't work. the system just > refused to update. > I am wondering the innodb in mysql doesn't support the > feature like on update cascade or on delete cascade? > thanks > bin > > ______________________________________________________________________ > Find, Connect Date! http://personals.yahoo.ca > > --------------------------------------------------------------------- > 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
