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/[EMAIL PROTECTED]

Reply via email to