php - 如何防止 MySQL 数值发生变化？ (phpMyAdmin)

Question

我已经在 phpMyAdmin 的 MySQL 中创建了表 INVOICES。

CREATE TABLE INVOICES(
 INVOICENUMBER       NUMERIC(3) NOT NULL PRIMARY KEY,
 JOBID               NUMERIC(3) NOT NULL,
 CURRENTDATE         DATE,
 CHARGEDETAILS       VARCHAR(200),
 CHARGESUBTOTAL      NUMERIC(3,2) NOT NULL CHECK (CHARGESUBTOTAL >= 0),
 GRANDTOTAL          NUMERIC(3,2) NOT NULL CHECK (GRANDTOTAL >= 0),
 FINALWORKLOG        VARCHAR(200),
 TERMS               VARCHAR(200),
 INDEX (JOBID)
 );

但是，我在尝试向表中添加记录时遇到了问题。第一个插入命令正确输入所有内容，但第二个命令将数值(CHARGESUBTOTAL 和 GRANDTOTAL)转换为表中的 9.99。我不确定是什么原因造成的，所以任何人都可以帮助我吗？

INSERT INTO INVOICES VALUES (1,1,'2014-11-15','None as the job was cancelled.',0.00,0.00,'The job was cancelled.','None.');
INSERT INTO INVOICES VALUES (2,2,'2014-11-15','£31.80 for total work.',31.80,35.00,'Employee took care of all the expected duties.','Payment should be undertaken within 7 days of receipt.');

Answer 1

NUMERIC(3,2) 表示 - 3 位整数和 2 位小数点。

http://dev.mysql.com/doc/refman/5.5/en/fixed-point-types.html