Integer Types

Minimal unsigned value is always 0.

Type | Storage(Bytes) | Minimum Value(Signed) | Maximum Value(Signed) | Maximum Value(Unsigned) | —— | —— | —— | —– | —– |TINYINT | 1 | -27-128 | 27-1127 | 28-1255SMALLINT | 2 | -215-32,768 | 215-132,767 | 216-165,535MEDIUMINT | 3 | -223-8,388,608 | 223-18,388,607 | 224-116,777,215INT | 4 | -231-2,147,483,648 | 231-12,147,483,647 | 232-14,294,967,295BIGINT | 8 | -263-9,223,372,036,854,775,808 | 263-1 9,223,372,036,854,775,807 | 264-118,446,744,073,709,551,615