2013年4月1日 星期一

MySQL(5.6) Integer Types

 Integer Types

TypeStorageMinimum ValueMaximum Value
(Bytes)(Signed/Unsigned)Signed/Unsigned)
TINYINT1-128127
0255
SMALLINT2-3276832767
065535
MEDIUMINT3-83886088388607
016777215
INT4-21474836482147483647
04294967295
BIGINT8-92233720368547758089223372036854775807
018446744073709551615

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

沒有留言: