[thelist] mysql: unique constraing and null default

Aleem Bawany aleem.bawany at utoronto.ca
Fri Feb 28 22:10:00 CST 2003

I have an email entry field, which is optional and hence can be left
blank. I want the field to be unique so no two users can have
dupes, but I want them to be able to leave it blank so the field
can be null and the default is null. I can't impose a unique
constraint, however, because then two rows can't be empty
(then they'll be dupes).

What should I do? (this sql biz is no fun)


[ http://aleembawany.com/ ]

More information about the thelist mailing list