Arul, Tuesday, June 04, 2002, 9:23:34 AM, you wrote: A> I have created a table parent and also another table child where parentid A> column in child is a foreign key to the id column in parent table A> Is it possible that i have no entries in parent table , and i am inserting A> null values for parentid in child table..
Since 3.23.50 you can set parentid to the NULL value. You can also use ON DELETE SET NULL clause, that will be automatically update parentid to the NULL value: http://www.mysql.com/doc/S/E/SEC446.html You can download 3.23.50 from the MySQL site: http://www.mysql.com/downloads/mysql-3.23-pre.html A> Regards, A> -Arul -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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