Hello I am a brand new user of MySql, and have some questions about using InnoDB tables.
I noticed in the manual that you can only specify - ON DELETE SET NULL Or - ON DELETE CASCADE What is the default behaviour if nothing is specified? Also, does anyone know if there are any plans to support additional options? Finally, when you have many tables with a foreign key referencing a table, how does this affect performance of updates on the table being referenced? Thanks. Chris --------------------------------------------------------------------- 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