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