David McNett

If this doesn't horrify you then you aren't really paying attention:

mysql> create table moo ( id mediumint(3) NOT NULL auto_increment, val numeric(4,2), primary key (id) ) type=innodb;
Query OK, 0 rows affected (0.04 sec)

mysql> insert into moo (val) values (123456789.01);
Query OK, 1 row affected (0.01 sec)

mysql> select * from moo;
+----+--------+
| id | val    |
+----+--------+
|  1 | 999.99 |
+----+--------+
1 row in set (0.00 sec)

mysql> update moo set val = val + 1;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 1

mysql> select * from moo;
+----+--------+
| id | val    |
+----+--------+
|  1 | 999.99 |
+----+--------+
1 row in set (0.00 sec)