Hi All MySQL Max doesnt support the feature of the column ,which is referred to be a foreign key , to be null
But the Inno Db Site says "We suppress the FOREIGN KEY check if any of the column values in the foreign key or referenced key to be checked is the SQL NULL.This is compatible with Oracle" Ref : http://www.innodb.com/ibman.html#InnoDB_foreign_keys The release is MySQL/InnoDB-3.23.50, April 23, 2002 But where do i get this version... In www.mysql.org i could only download Max 3.23.49 Any ideas.. -Arul --------------------------------------------------------------------- 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