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]