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` char(16) default NULL, PRIMARY KEY (`ID`), UNIQUE KEY `DomainName` (`DomainName`,`Alias`), ) ENGINE=InnoDB DEFAULT CHARSET=latin1 The way I read this definition, it should be impossible for someone to put in two rows with the same DomainName and Alias, however, right now I have the following rows in the table: +-----+---------+------------+-------+ | ID | WebSite | DomainName | Alias | +-----+---------+------------+-------+ | 543 | 1086 | 1334 | NULL | | 545 | 1086 | 1334 | NULL | | 509 | 1086 | 1334 | * | +-----+---------+------------+-------+ And I can insert even more NULL rows if I want to. Shouldn't the UNIQUE key prevent this from happening? Tim Gustafson MEI Technology Consulting, Inc [EMAIL PROTECTED] (516) 379-0001 Office (516) 480-1870 Mobile/Emergencies (516) 908-4185 Fax http://www.meitech.com/
smime.p7s
Description: S/MIME cryptographic signature
