right...
----- Original Message -----
From: "Gabriel PREDA" <[EMAIL PROTECTED]>
To: "Ferindo Middleton" <[EMAIL PROTECTED]>
Cc: "Dan Buettner" <[EMAIL PROTECTED]>; <mysql@lists.mysql.com>
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/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]