mysql 中浮点型与定点型记录_MySQL

mysql> CREATE TABLE test (c1 float(10,2),c2 decimal(10,2));

Query OK, 0 rows affected (0.22 sec)

mysql> insert into test values(131072.32,131072.32);

Query OK, 1 row affected (0.02 sec)

mysql> insert into test values (999998.02, 999998.02);
Query OK, 1 row affected (0.02 sec)

mysql> select * from test;

+-----------+-----------+

| c1  | c2  |

+-----------+-----------+

| 131072.31 | 131072.32 |

| 999998.00 | 999998.02 |

+-----------+-----------+

1 row in set (0.00 sec)