On Tuesday 09 April 2002 11:47 am, Alain Del Giust wrote: > I am just testing mySQL so I will be able to use it instead of Oracle > Sybase ... > > I am not saying a PK can be NULL wich is impossible > But a FK can be NULL and I'd like to know how to do that with mySQL
I do not see this as being allowed in SQL92. In fact, my documentation says specifically that it is not allowed. That said, I understand now why you would want to do this. It seems to me that perhaps you just want to do without a foreign key and enforce the constraint programmatically? --------------------------------------------------------------------- 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