页次: 1
mysql> select version(); +------------+ | version() | +------------+ | 5.6.12-log | +------------+ 1 row in set (0.00 sec) mysql> create table `ipbbs` ( qian decimal(65, 30) ); Query OK, 0 rows affected (0.26 sec) mysql> create table `ipbbs` ( qian decimal(66, 30) ); ERROR 1426 (42000): Too big precision 66 specified for column 'qian'. Maximum is 65. mysql> create table `ipbbs` ( qian decimal(65, 31) ); ERROR 1425 (42000): Too big scale 31 specified for column 'qian'. Maximum is 30.
这需要用到decimal类型的, 65, 30
ipbbs.net
离线
页次: 1