THANK_YOU! I was modifying entries for a joiner table without checking to see tif they were already present! > Subject: RE: Duplicate entry error?? > > > > 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 > > > > 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