Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

mysql smallint range

--			SIGNED										  UNSIGNED
--			Min               		Max                   Min Max
TINYINT     -128                    127                   0   255
SMALLINT    -32767                  32767                 0   65535
MEDIUMINT   -8388608                388608                0   16777215
INT         -2147483648             2147483647            0   4294967295
INTEGER     -2147483648             2147483647            0   4294967295
BIGINT      -9223372036854775808    9223372036854775808   0   18446744073709551615
Source by www.techonthenet.com #
 
PREVIOUS NEXT
Tagged: #mysql #smallint #range
ADD COMMENT
Topic
Name
7+1 =