+--------------+-------+---------------------------+----------------+ |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 | | +--------------+-------+---------------------------+----------------+
|