Unless I've misread your post, this was not so much a feature in .51 as it was a bug. If you have a FK contraint then you should never be able to insert a record into the child table that does not have a matching FK in the parent table. (Null does not mean no matching record.)
Either remove the constraint, add a dummy record into the parent table or re-think what you are trying to do. (You've put on a constraint and now you are trying to break it!) =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -----Original Message----- From: Arul [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 9:14 AM To: MySQL Subject: Mysql 4.0.2 Hi As i already stated , i am not able to insert a null value in a child table in 4.0.1 which i was able to do in 3.23.51 I have created a table parent and also another table child where parentid column in child is a foreign key to the id column in parent table It was possible that i have no entries in parent table , and i was able to insert null values for parentid in child table.. This was a feature in 3.23.51 whereas this was not available in 3.23.49 Any idea whether this will be supported in 4.0.2 and where i can get that from.. In the MySQL site i could see only upto 4.0.1 alpha release.. -Arul sql,query --------------------------------------------------------------------- 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
