Mysql中显示宽度指的是什么？

pupilzeng

比方说

1. 
   
2. mysql> create table test
   
3.     -> (id INT(5) PRIMARY KEY NOT NULL AUTO_INCREMENT,
   
4.     -> name CHAR(5) NOT NULL,
   
5.     -> num FLOAT(6,2));
   
6. Query OK, 0 rows affected (0.06 sec)
   
7. 
   
8. mysql> insert into test
   
9.     -> values(NULL, "ABC", 123456.7891);
   
10. Query OK, 1 row affected (0.00 sec)
    
11. 
    
12. mysql> SELECT * FROM test;
    
13. +----+------+-----------+
    
14. | id | name | num       |
    
15. +----+------+-----------+
    
16. |  1 | ABC  | 123456.79 |
    
17. +----+------+-----------+
    
18. 1 row in set (0.00 sec)
    
19. 
    

复制代码

这里的FLOAT(6.2)怎么解释？

深空

6.2表示6个整数位，2个小数位，呵呵

pupilzeng

那我
mysql> insert into test
    -> values(NULL, "ABC", 123456789.7891);
Query OK, 1 row affected (0.00 sec)
mysql> SELECT * FROM test;
+----+------+--------------+
| id | name | num          |
+----+------+--------------+
|  1 | ABC  |    123456.79 |
|  2 | ABC  | 123456792.00 |
+----+------+--------------+
最后的那一组数是怎么回事呢？就是说如果我的整数位超过了6位，它是怎么处理的？