127 2016 int

TypeStorageMinimum ValueMaximum Value
 (Bytes)(Signed/Unsigned)(Signed/Unsigned)
TINYINT 1 -128 127
    0 255
SMALLINT 2 -32768 32767
    0 65535
MEDIUMINT 3 -8388608 8388607
    0 16777215
INT 4 -2147483648 2147483647
    0 4294967295
BIGINT 8 -9223372036854775808 9223372036854775807
    0 18446744073709551615

http://dev.mysql.com/doc/refman/5.7/en/integer-types.html

posted @ 2016-11-29 14:43  papering  阅读(137)  评论(0编辑  收藏  举报