MySQL_bigint(20) 是什么意思
MySQL中各数据类型的取值范围
无符号(unsigned)和有符号(signed)两种类型(float和double总是带符号的)
一个int能存储的数据的范围为-3276832767,而unsigned能存储的数据范围则是065535
TINYINT tinyint
-128 - 127
TINYINT UNSIGNED tinyint unsigned
0 - 255
SMALLINT smallint
-32768 - 32767
SMALLINT UNSIGNED smallint unsigned
0 - 65535
MEDIUMINT mediumint
-8388608 - 8388607
MEDIUMINT UNSIGNED mediumint unsigned
0 - 16777215
INT 或 INTEGER int integer
-2147483648 - 2147483647