:[EMAIL PROTECTED]
Sent: Tuesday, February 22, 2005 3:13 PM
To: Gustafson, Tim; mysql@lists.mysql.com
Subject: Re: UNIQUE Key Allowing Duplicate NULL Values
At 15:00 -0500 2/22/05, Gustafson, Tim wrote:
Hi there!
I have a table, defined as follows:
CREATE TABLE `WebSiteDomainNames` (
`ID` int
have to use a BDB table, because only BDB allows a single
NULL per UNIQUE index.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 22, 2005 3:13 PM
To: Gustafson, Tim; mysql@lists.mysql.com
Subject: Re: UNIQUE Key Allowing Duplicate NULL Values
At 15:00
/
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 23, 2005 8:14 AM
To: Gustafson, Tim; mysql@lists.mysql.com
Subject: RE: UNIQUE Key Allowing Duplicate NULL Values
At 8:10 -0500 2/23/05, Gustafson, Tim wrote:
Is there any flag I can set
Tim,
Oh well, thanks anyhow.
If I could put in a feature suggestion, it would be a flag that I could
set to disallow duplicate nulls. :)
What for?
NULL is not equal to NULL. Period.
If you don't want NULLs, make the column not null.
The specification is correct.
With regards,
Martijn
@lists.mysql.com
Subject: Re: UNIQUE Key Allowing Duplicate NULL Values
Tim,
Oh well, thanks anyhow.
If I could put in a feature suggestion, it would be a flag that I
could
set to disallow duplicate nulls. :)
What for?
NULL is not equal to NULL. Period.
If you don't want NULLs, make
The problem is that I don't want more than one row in the table that has
a null value in the column. As you've pointed out in your e-mail,
there's a difference between NULL and BLANK. It's not that I don't want
NULL values, it's that I don't want MORE THAN ONE.
I can easily continue
Tim,
The table in question is used to store aliases to web sites. That is,
meitech.com is the main web site, and www.meitech.com is the alias.
So, the first column is the domain name in question, and the second on
is the host name part of the alias, in this example www.
Now, I also have
In article [EMAIL PROTECTED],
Gustafson, Tim [EMAIL PROTECTED] writes:
Martijn,
The problem is that I don't want more than one row in the table that has
a null value in the column. As you've pointed out in your e-mail,
there's a difference between NULL and BLANK. It's not that I don't want
At 15:00 -0500 2/22/05, Gustafson, Tim wrote:
Hi there!
I have a table, defined as follows:
CREATE TABLE `WebSiteDomainNames` (
`ID` int(10) unsigned NOT NULL auto_increment,
`WebSite` int(10) unsigned NOT NULL default '0',
`DomainName` int(10) unsigned NOT NULL default '0',
`Alias`