right...
----- Original Message -----
From: "Gabriel PREDA" <gabriel.preda@stripped>
To: "Ferindo Middleton" <ferindo.middleton@stripped>
Cc: "Dan Buettner" <drbuettner@stripped>; <mysql@stripped>
Sent: Friday, October 06, 2006 6:31 PM
Subject: Re: multiple primary keys on one table?
> You will have to UPDATE to NULL those fields, modify the aplication to
> enter NULL instead of empty-string... Then add the UNIQUE INDEX...
>
> In MySQL (unless modified) the dafault is that NULL values are
> incomparable thus allowing the creation of a UNIQUE INDEX.
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- --
> Gabriel PREDA
> Senior Web Developer
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
