On Tue, Jan 14, 2003 at 12:20:06PM +0200, Octavian Rasnita wrote: > I've read the following text in a book: > > ANSI SQL supports a special kind of key called a foreign key. Foreign keys > help protect database integrity by enabling the database to manage things > such as the deletion of rows with dependent relationships in other tables. > Though MySQL supports the ANSI syntax for foreign keys, it does not actually > use them to perform integrity checking in the database. This is a situation > in which the introduction of a feature would cause a slowdown in performance > with little real benefit. Applications themselves should generally worry > about foreign key integrity. > > What does this mean?
This means that the book is out of date. :) > Does MySQL allow using foreign keys or not? The InnoDB table type has some support for foreign keys. Read more at http://www.mysql.com/doc/en/SEC449.html Cheers! -- Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Display the option files read by the server % mysqld --help Email signature rotated by Signify v1.10 <http://www.debian.org/> --------------------------------------------------------------------- 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
