Mysql float数值类型的使用
float类型在使用的时候应该注意些什么呢。直接设置成float,默认的是几位整数与几位小数??
mysql> create table test(id float,id2 float(12,4));
Query OK, 0 rows affected (0.01 sec)
mysql> insert into test values(123456.2341,2342334,5234);
ERROR 1136 (21S01): Column count doesn't match value count at row 1
mysql> insert into test values(123456.2341,234233.5234);
Query OK, 1 row affected (0.00 sec)
mysql> select * from test;
+--------+-------------+
| id | id2 |
+--------+-------------+
| 123456 | 234233.5156 |
+--------+-------------+
1 row in set (0.00 sec)
这样的近似值 ,该怎么解释???