小问题求教各位高手,关于数据类型float
mysql> create table da_tx2(id int unsigned,name char(4),score float(3,2))engine=innodb charset=utf8mb4 comment'数据类型测试';Query OK, 0 rows affected, 1 warning (0.01 sec)
mysql> insert into da_tx2 values(1,'li',95.1);
ERROR 1264 (22003): Out of range value for column 'score' at row 1
为啥报错啊,float(3,2),不是代表整数占3位,小数占2位,我填写95.1为何超出范围啊!