UPDATE t_borrow_amount SET amount=amount-1 WHERE id=1901
上面这条语句在MYSQL5.1版本中会出现问题,当字段amount值小于0时会被自动填充为4294967295
我们需要将语句改成:
UPDATE t_borrow_amount SET `amount` = CONVERT( amount + (-1) ,SIGNED ) WHERE id=1901
UPDATE t_borrow_amount SET amount=amount-1 WHERE id=1901
上面这条语句在MYSQL5.1版本中会出现问题,当字段amount值小于0时会被自动填充为4294967295
我们需要将语句改成:
UPDATE t_borrow_amount SET `amount` = CONVERT( amount + (-1) ,SIGNED ) WHERE id=1901