back to my unique constraint again :) i asked on irc but couldnt get anything out of them so i came here. got a unique constraint with serveral columsn like so.. UNIQUE (col1,col2,col3) id like to have col2 and col3 to use null values but it doesnt seem to like this. Is there a way i can use columns with NULL in a composite unique constraint like the one above thanks -Josh (sql) --------------------------------------------------------------------- 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
