|
#2
阳光上的桥2023-01-13 15:07
|
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为何超出范围啊！