At 4:36 PM -0700 3/13/07, jerad sloan wrote:
thanks.
i had an extra index setup for one of my fields...i deleted it and
it started working as expected...but now the same thing is happening
again.
i'm getting the error
"Duplicate entry
'http://vids.myspace.com/index.cfm?fuseaction=vids.individual&vid'
for key 2"
when doing the following
insert into tblvideoURL
(videourl,userid,shortname,videourlcreated,videoURLcurrentstatus
,xmltitle ) values
('http://vids.myspace.com/index.cfm?fuseaction=vids.individual&videoid=1951753288',3,'MySpace',{ts
'2007-03-13 15:04:01'},404 ,'Sporting Riff Raff - Absolutely Wasted
(director unknown - hopefully Emily?!)' )
here is the Show Create Table
<SNIP>
PRIMARY KEY (`videourlID`),
UNIQUE KEY `videourl` (`videourl`),
KEY `videoURLcurrentstatus` (`videourlcurrentstatus`),
Key 2 is defined as unique; thus, the error message says you're
inserting a record where videourl duplicates an existing record.
Solutions:
(1) don't do that.
(2) drop index videourl
(3) drop index videourl; create index videourl (videourl).
(4) if you want to ensure uniqueness across a set of columns, define
a unique composite key, for instance: create unique index01
(videourl,userid);
Indexes/keys do not have to be unique unless they are primary or
defined as unique.
steve
--
+--------------- my people are the people of the dessert, ---------------+
| Steve Edberg http://pgfsun.ucdavis.edu/ |
| UC Davis Genome Center [EMAIL PROTECTED] |
| Bioinformatics programming/database/sysadmin (530)754-9127 |
+---------------- said t e lawrence, picking up his fork ----------------+
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
