1. DBA2011.1.6

2. 3. 4. 5. 6. BD 7. 17 48 4228 776 BD102 BD 42 8. 920 , DBA, , Hi ID100001633087271 100001922882511FF3F 9. select * from user_071 where userid=100001633087271;+-----------------+--------------+-----------------+----------------+---------------+--------+--------------+----------+---------------+| userId| totalCharged | totalVIPConsume | | frozenCredits | points | vipValidTime | vipLevel | accountStatus |+-----------------+--------------+-----------------+----------------+---------------+--------+--------------+----------+---------------+| 100001633087271 |0 |164500 |4294768395| 0 |0 |0 |0 | 0 |+-----------------+--------------+-----------------+----------------+---------------+--------+--------------+----------+---------------+1 row in set (0.00 sec)[root@tw-pay-db1a binlog]# mysqlbinlog mysql-bin3310.000122INSERT INTO `user_011` ( `userId` , `creditsBalance` , `totalVIPConsume` , `vipLevel` ) VALUES( 100001922882511 , 4294770295 - 1000 , 211980 + 1000 , 0 ) ON DUPLICATE KEY UPDATE`creditsBalance` = `creditsBalance` - 1000 , `totalVIPConsume` = `totalVIPConsume` + 1000 ,`vipLevel` = 0 10. -30F >0update user_071 setcreditsBalance=creditsBalance-30where userid=100001633087271 BUG creditsBalance=20F4294768395F50F 11. -30F >0update user_071 setcreditsBalance=creditsBalance-30where userid=100001633087271and creditsBalance>30 BUG creditsBalance=4294768395F20F 12. SQLmysql