List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:February 12 2007 6:59pm
Subject:Re: Update failing with error 1062
View as plain text  
Simon,

   send in the schema for the table in question, that should show
something.   The only condition I can think of off the top of my head
which might do that is if you have another unique key in your
structure and that is the one this error is complaining about.

On 2/12/07, Simon Giddings <sgiddings@stripped> wrote:
> Good morning,
>
> I issue an update statement containing a where clause on the primary
> index, so as to update a single record. Howerver this is failing with
> "Duplicate entry '6' for key 1" -
> update clients.calendarentry set Subject = 'presentation' where
> idCalendarEntry = 6;
>
> In the table, the field 'idCalendarEntry' is declared as :
> `idCalendarEntry` int(10) unsigned NOT NULL auto_increment
>
> The server version of MySql I am using is 5.0.24
> The client version of MySql I am using is 5.0.11
>
> Is anyone able to help?
> Simon
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


-- 
  - michael dykman
 - mdykman@stripped
Thread
Update failing with error 1062Simon Giddings12 Feb
  • Re: Update failing with error 1062Devi12 Feb
  • Re: Update failing with error 1062Michael Dykman12 Feb
    • Re: Update failing with error 1062Simon Giddings13 Feb
Re: Update failing with error 1062Simon Giddings14 Feb