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