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 fi
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 <[EMAIL PROTECTED]> wrote:
Found the source of my problem.
I had an update trigger connected to this table which was trying to
create a new entry in another table instead of updating an existing one!
There we go!
Simon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:
