CREATE TABLE `money` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` char(10) DEFAULT NULL,
`money` decimal(20,2) unsigned DEFAULT '0.00',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8
mysql> select * from money;
+----+-------+----------+
| id | name | money |
+----+-------+----------+
| 1 | lilei | 4000.00 |
| 2 | lucy | 15000.00 |
+----+-------+----------+
2 rows in set (0.00 sec)
这时
mysql> update money set money = money-4500 where name ='lilei';
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 1
这个为什么能成功啊, 如何设置不能成功