[摘要]+----------------+------------------+2 rows in set (0.00 sec)再举例： DECIMAL(5,2)mysql> create tabl...
+----------------+------------------+
2 rows in set (0.00 sec)
再举例： DECIMAL(5,2)
mysql> create table t1(id1 float(5,2) default null,id2 double(5,2) default null,id3 decimal(5,2) default null );
mysql> insert into t1 values(1.2345,1.2345,1.2345);Query OK, 1 row affected, 1 warning (0.04 sec)
mysql> show warnings;
+-------+------+------------------------------------------+
关键词：具体介绍MySQL中Decimal分类与Float Double的区别