What's the maximum value of smallint(6) unsigned in MySQL?
在MySQL中，smallint(6)未签名的最大值是多少?
2 个解决方案
#1
49
According to official MySQL documentation, the maximum value of an unsigned smallint is 65535.
根据MySQL官方文档，unsigned smallint的最大值是65535。
The (6) portion has no effect on the allowed range of the column; it only affects the display of the column in the MySQL command line interface.
(6)部分不影响列的允许范围;它只影响MySQL命令行接口中列的显示。
#2
4
An smallint unsigned max value is 65535 and uses 2 bytes
一个smallint unsigned max值是65535，使用两个字节。
MySQL参考
#1
49
According to official MySQL documentation, the maximum value of an unsigned smallint is 65535.
根据MySQL官方文档，unsigned smallint的最大值是65535。
The (6) portion has no effect on the allowed range of the column; it only affects the display of the column in the MySQL command line interface.
(6)部分不影响列的允许范围;它只影响MySQL命令行接口中列的显示。
#2
4
An smallint unsigned max value is 65535 and uses 2 bytes
一个smallint unsigned max值是65535，使用两个字节。
MySQL参考