List:General Discussion« Previous MessageNext Message »
From:Renish Date:October 6 2006 10:41am
Subject:Re: multiple primary keys on one table?
View as plain text  
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
> 

Thread
multiple primary keys on one table?Ferindo Middleton5 Oct
  • Re: multiple primary keys on one table?Dan Buettner5 Oct
    • Re: multiple primary keys on one table?Ferindo Middleton6 Oct
      • Re: multiple primary keys on one table?Gabriel PREDA6 Oct
  • Re: multiple primary keys on one table?Miles Thompson6 Oct
  • Re: multiple primary keys on one table?Martijn Tonies6 Oct
  • Re: multiple primary keys on one table?Renish6 Oct