From: jerad sloan (jeradsloangmail.com)
Date: Tue Mar 13 2007 - 19:24:28 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

thanks for the quick reply.

i want that to be unique so there is no way to insert the same URL
more than once.
there isn't a record with that URL...but it gives the error
anyway...it seems to be just checking a portion of the entry i'm
trying to insert.
i don't want uniqueness across a set of columns...just that one column.

what do you mean by
(3) drop index videourl; create index videourl (videourl).
drop the unique index and create a non-unique index?
that isn't what i'm trying to do...i need it to be unique.

thanks,
jerad

On Mar 13, 2007, at 4:55 PM, Steve Edberg wrote:

> 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 ,xml
>> title ) 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
> sbedbergucdavis.edu |
> | 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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]