Ilham,
It means what it says.You are attempting to insert into a table
that has a primary or other unique key and that data which you are
trying to insert already has that unique value. To diagnose, it would
be helpful to know the circumstance under which you got this error
message.
- micha
2009/12/13 Victor Subervi :
[...]
> Please advise.
review your sql: you are inserting into
tem126072414516
and selecting from
tem126072385457
( Asterisk in Pinter Tibor's mail means "bold" )
Greetings,
Mattia Merzi.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Gods. What is this, a creche ?
*plonk*
On Sun, Dec 13, 2009 at 6:44 PM, Victor Subervi wrote:
> On Sun, Dec 13, 2009 at 12:21 PM, Pinter Tibor wrote:
>
> > Victor Subervi wrote:
> >
> >> Hi;
> >>
> >> mysql> insert into *tem126072414516* (ProdID, Quantity) values ("2",
> "2");
> >> mysql> sele
On Sun, Dec 13, 2009 at 12:21 PM, Pinter Tibor wrote:
> Victor Subervi wrote:
>
>> Hi;
>>
>> mysql> insert into *tem126072414516* (ProdID, Quantity) values ("2", "2");
>> mysql> select * from *tem126072385457*;
>>
>
>
mysql> insert into *tem126072414516* (ProdID, Quantity) values ("2", "2");
ERRO
Victor Subervi wrote:
Hi;
mysql> insert into *tem126072414516* (ProdID, Quantity) values ("2", "2");
mysql> select * from *tem126072385457*;
t
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
[EMAIL PROTECTED] wrote:
Ronan McGlue <[EMAIL PROTECTED]> wrote on 03/09/2006 05:05:15 AM:
> i have a little quirck with my current Mysql setup. I log all messages
> from my mtas into Mysql and then use a simple query to generate stats
> from them... as below:
>
> mysql> select exim.hour,
Ronan McGlue <[EMAIL PROTECTED]> wrote on 03/09/2006 05:05:15 AM:
> i have a little quirck with my current Mysql setup. I log all messages
> from my mtas into Mysql and then use a simple query to generate stats
> from them... as below:
>
> mysql> select exim.hour,sum(exim.count),stats.spam,stat
Hello.
> | 4.0.17-standard |
It is an old version of MySQL which could contain lots of bugs. It is
strongly recommended to upgrade to the latest release 4.1.12, or if it
is impossible in your production environment to 4.0.24. Usually upgrade
solves such kind of errors. Please, next
ag
>
>
> -Original Message-
> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 30, 2005 3:20 PM
> To: mysql@lists.mysql.com
> Subject: Re: Duplicate entry error
>
>
> Hello.
>
> Please examine your master's
in for your help and cooperation.
Anurag
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 30, 2005 3:20 PM
To: mysql@lists.mysql.com
Subject: Re: Duplicate entry error
Hello.
Please examine your master's binary and slave's relay logs with
Hello.
Please examine your master's binary and slave's relay logs with
mysqlbinlog utility to find if sent and received SQL statements are
different. Sent your MySQL versions on master and slave. Include complete
output of 'SHOW SLAVE STATUS'. If your version is rather old, check if the
prob
Did you actually stop all writes to the master data while you were copying
the data over to the slave database? Is it possible that the connection you
issued the read lock with timed out before the transfer was completed?
-Original Message-
From: Alex Greg
To: [EMAIL PROTECTED]
Sent: 9/2/
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Samyukta Akunuru wrote:
> Hi,
>
> I am getting following error while using Hibernate with mySql.Any help
appreciated. Thank you!
>
> 2004-01-28 14:02:51,037 [main] ERROR
net.sf.hibernate.util.JDBCExceptionReporter - Invalid argument value,
message from
Ivan Lulukyan writes:
> Hi All.
> Strange thing.The query below:
>
> select concat(domain,path,file) as url, title, '' as blank1, docdate, size,
> date as lastmod, 'keywords' as keyw, description as descr, a.ID, sum((word
> like 'acc')) as r, ( sum(word like 'acc')) as qu, f.ID, author,
> class,c
Dear Ivan,
I am full of admiration for your huge number of left joins in this
query! :-)
Looks quite funny to me how a SELECT can produce an error that you would
expect from an INSERT query. Anyway, try to type this query into a
multi-line command line (MySQL Monitor, the command line tool), and
Try to design your tables so, that it would be impossible to enter
dublicate primary keys. And don't let users (if it's CGi application) to
set or play with your primary keys (well, we could talk more about this
one).
If you used AUTO_INCREMENT, or UNIQUE, I bet you wouldn't have such
problem.
Thanks Cal,
Anything in particular in the config I should be looking for?
Thanks,
Tyrone
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 13, 2001 9:40 AM
To: Mysql@Lists. Mysql. Com
Subject: RE: Duplicate entry '0' for key 1
Other than the f
levans.com
-Original Message-
From: Tyrone Mills [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 13, 2001 11:24 AM
To: Mysql@Lists. Mysql. Com
Subject: RE: Duplicate entry '0' for key 1
Here's the CREATE TABLE syntax I used on the latest table to do this to
me...
CREATE TABLE sit
[mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 13, 2001 9:06 AM
To: Tyrone Mills; Mysql@Lists. Mysql. Com
Subject: RE: Duplicate entry '0' for key 1
What's your datatype?
Cal
http://www.calevans.com
-Original Message-
From: Tyrone Mills [mailto:[EMAIL PROTECTED]]
Sent: Su
What's your datatype?
Cal
http://www.calevans.com
-Original Message-
From: Tyrone Mills [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 13, 2001 10:59 AM
To: Mysql@Lists. Mysql. Com
Subject: Duplicate entry '0' for key 1
Importance: High
Why is it that a seemingly random intervals anyo
Tobias Wolff wrote:
>
> Hello,
> I have searched the mailing list for this topic, but didn't find a match vor
> my problem.
>
> I am working on Linux Mandrake with MySQL 3.23.33 installed from the RPMs
> for Mandrake. I am trying to convert a ACCESS database to MySQL using a perl
> script. The s
If you are using MS Access, the easiest way is to export the tables via the ODBC
driver. Simply right click on your table name, then click export. At the bottom of the
list there the ODBC option. I haven't had any problems using this method of
transferring tables, other than the fact that MySQL
You have set EKey to be unique, so if you already have another row with
EKey = 13, you cannot establish an additional row with the same key.
(unique keys can be either set by primary key(), or unique())
.. Atle
On Mon, 12 Feb 2001, Paul Wilkinson wrote:
> Thanks in advance for your help!
>
Hi,
You have a unique key defined which includes Ekey and another field (the key
2 mentioned in the error message), and the entry "other_field = '88' and
Ekey='252'" has already been used.
Regards
Quentin
-Original Message-
From: Paul Wilkinson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
24 matches
Mail list logo
