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!
>
> How does one replace a single field value when the value repeats? I tryed
> the following and get an error message "Duplicate entry '88-252' for key 2"
>
> UPDATE DKWords SET EKey='252' WHERE EKey='13'
> What is wrong?
>
> Paul
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
