Hi,
You have a unique key defined which includes Ekey and another field (the key
2 mentioned in the error message), and the entry "other_field = '88' and
Ekey='252'" has already been used.
Regards
Quentin
-----Original Message-----
From: Paul Wilkinson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 13 February 2001 10:39
To: Help MySQL List
Subject: Duplicate entry error??
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
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error
you are asked to destroy this email and contact the sender immediately.
Your assistance is appreciated.
---------------------------------------------------------------------
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
