Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: jerad sloan (jeradsloangmail.com)
Date: Tue Mar 13 2007 - 19:24:28 CDT
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.
On Mar 13, 2007, at 4:55 PM, Steve Edberg wrote:
> At 4:36 PM -0700 3/13/07, jerad sloan wrote:
>> 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?
>> '2007-03-13 15:04:01'},404 ,'Sporting Riff Raff - Absolutely
>> Wasted (director unknown - hopefully Emily?!)' )
>> here is the Show Create Table
>> 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.
> (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
> Indexes/keys do not have to be unique unless they are primary or
> defined as unique.
> +--------------- 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