Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- Unique index on column with null values


arms - 3:17 pm on Nov 17, 2011 (gmt 0)


By your own definition you can't have a unique key on a field with duplicate values (null or otherwise), but you could create another field with an autonumber and create a compound key with the email address field, this would then be uniqur but retain the original values in the email field


Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4387993.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com