Mega Code Archive
Integer Types in MySQL with Sizes and Ranges
<![CDATA[
+--------------+-------+---------------------------+----------------+
|Integer Type | Bytes | Signed |Unsigned |
+--------------+-------+---------------------------+----------------+
|TINYINT | 1 | -128 through 127 | 0 through 255 |
+--------------+-------+---------------------------+----------------+
|SMALLINT | 2 |-32,768 through 32,767 |0 through 65,535|
+--------------+-------+---------------------------+----------------+
|MEDIUMINT | 3 |-8,338,608 through |0 through |
| | | 8,388,607 | 16,777,215 |
+--------------+-------+---------------------------+----------------+
|INT | 4 |-2,147,483,648 |0 through |
| | |through 2,147,483,487 | 4,294,967,295 |
+--------------+-------+---------------------------+----------------+
|BIGINT |8 |-9,223,372,036,854,775,808 |0 through |
| | |through |18,446,744,073,709,551,615
| | |9,223,372,036,854,775,807 | |
+--------------+-------+---------------------------+----------------+
]]>