Hello all!
How can this happen:
- Table with 537 rows - value of column q02 is 10 in all rows
- UPDATE table SET q02=q02+20 ;
-> Query OK, 1074 rows affected (0.19 sec)
Rows matched: 1074 Changed: 1074 Warnings: 0
??? Why 1074 Rows?
-> Result: all 537 show value 50 in column q02 (!! not 30 as expected 10+20=30).
It seems that every row was touched twice by the update statement.
Why? What went wrong with the system? What can I do to repair and prevent this?
Ciao, Stephan
P.S.
- q02 is not a key
- isamchk -e doesn't report any errors
- MySQL 3.22.32 on FreeBSD
---------------------------------------------------------------------
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