Hi, Could you give us SHOW CREATE TABLE your_table ?
Greetings from France too ;) Jocelyn ----- Original Message ----- From: "BPF Webmaster" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Thursday, November 21, 2002 2:25 PM Subject: Duplicate key delete record with same key > Using PHP 4.2.3 with MySQL 3.23.52 > > Report: > ------- > - Table has 2 keys: 'account' as PRIMARY and 'id' as unique > - I make an SQL update on an existing a record with id="anid" setting > id="anotherid" but another record exists with id ="anotherid" > - The update is performed and the record already existing with > id="anotherid" is deleted!!! > > Expected behavior: > ------------------ > - Update failed with "Duplicate key attempt message" > I guess it's a bug, isn't it? > > The workaround is very easy but I really guess the behavior is weird. > > Greetings from France, > JM > > > --------------------------------------------------------------------- > 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 > > > > --------------------------------------------------------------------- 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