Hi all... I am having a problem with unique key violations in one of my tables. This is the table structure:
CREATE TABLE `optionaldata` ( `ForeignID` int(10) unsigned NOT NULL default '0', `FieldID` int(10) unsigned NOT NULL default '0', `Value` char(200) default NULL, UNIQUE KEY `CitizenID_FieldID_Value` (`ForeignID`,`FieldID`,`Value`), ) TYPE=MyISAM; I am getting quite a few rows in the table that are duplicates, ie: 1068715, 60, '[EMAIL PROTECTED]' 1068715, 60, '[EMAIL PROTECTED]' What I want to know is, should this be possible under any circumstances at all? I am using some UPDATE IGNORE calls to this table, but from what I read in the documentation, this still shouldn't happen. Any ideas? Many thanks in advance, Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]