thanks for the suggestions.
doing the insert in the commandline gives the same error.
i deleted all the other indexes except the one in question (just to
see if it changed anything)...same error.
did a check table (and a repair table and an optimize table) - no
change.
is it possible the
At 5:24 PM -0700 3/13/07, jerad sloan wrote:
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 in
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
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.indivi
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 followi
Jerad -
First of all, please reply all with a SHOW CREATE TABLE of the table
you're inserting the row into, so that we can identify the indexes
you've established for the table.
thanks,
--bemansell
On 3/7/07, jerad sloan <[EMAIL PROTECTED]> wrote:
when i try to insert the string "
http://vids.
when i try to insert the string "
http://vids.myspace.com/index.cfm?fuseaction=vids.individual&videoid=2012774576";,
it returns
"error : Duplicate entry '
http://vids.myspace.com/index.cfm?fuseaction=vids.individual&videoid=' for
key 3"
when i check the table and do a search for the string, there
CREATE TABLE tbllayer (
LayerID int(11) NOT NULL default '0',
LayerSize int(11) NOT NULL default '0',
IceTypeID int(11) NOT NULL default '0',
Fingerprint char(16) binary default NULL,
PRIMARY KEY (LayerID),
UNIQUE KEY Fingerprint (Fingerprint),
KEY IceTypeID (IceTypeID)
) TYPE=MyISAM
AR>> I want to write sql query to duplicate a row. It has a PRI key called ID.
AR>> The MySQL database looks like
AR>> IDNameAddress
AR>> 345 Aman42, sb
AR>> 346
AR>> 347...
AR>> I want to duplicate the ID=345.
AR>> Any suggestions ?
VR> You can have d
Aman,
Monday, July 15, 2002, 8:35:16 PM, you wrote:
AR> I want to write sql query to duplicate a row. It has a PRI key called ID.
AR> The MySQL database looks like
AR> IDNameAddress
AR> 345 Aman42, sb
AR> 346
AR> 347...
AR> I want to duplicate the ID=345
Hi
I want to write sql query to duplicate a row. It has a PRI key called ID.
The MySQL database looks like
IDNameAddress
345 Aman42, sb
346
347...
I want to duplicate the ID=345.
Any suggestions ?
Thanks in advance.
Aman
__
The answer is there ... :
http://www.mysql.com/doc/L/O/LOAD_DATA.html
Gurhan
-Original Message-
From: Wong Zach-CHZ013 [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 8:18 PM
To: Wong Zach-CHZ013; '[EMAIL PROTECTED]'
Subject: RE: Duplicate Record
> -Ori
> -Original Message-
> From: Wong Zach-CHZ013
> Sent: Wednesday, May 22, 2002 7:11 PM
> To: [EMAIL PROTECTED]
> Subject: Duplicate Record
>
> Hi
> 1) Suppose, in a file, say testfile.sql,
> it contains a line
> eg:
> LOAD DATA INFI
Hi
1) Suppose, in a file, say testfile.sql,
it contains a line
eg:
LOAD DATA INFILE "mlc_stat_" INTO table mlc FIELDS TERMINATED BY '|' ;
And further suppose the record in file mlc_stat_ already exists in the
table mlc.
Does MySQL have the ability to stop inserting this duplicated record
Hi
1) Suppose, in a file, say testfile.sql,
it contains a line
eg:
LOAD DATA INFILE "mlc_stat_" INTO table mlc FIELDS TERMINATED BY '|' ;
And further suppose the record in file mlc_stat_ already exists in the
table mlc.
Does MySQL have the ability to stop inserting this duplicated record
15 matches
Mail list logo
