Exact Numeric (Integer) Datatypes

bigint – whole numbers between -2⁶³ and +2⁶³ - 1 (-9,233,372,036,854,775,808 and +9,233,372,036,854,775,807), inclusive

int – whole numbers between -2³¹ and +2³¹ - 1 (-2,147,483,648 and +2,147,483,647), inclusive

smallint – whole numbers between -2¹⁵ and +2¹⁵ - 1 (-32,768 and +32,767), inclusive

tinyint – positive whole numbers between 0 and 255, inclusive

unsigned bigint – whole numbers between 0 and 18,446,744, 073, 709,551,615, inclusive

unsigned int – whole numbers between 0 and 4,294,967,295, inclusive

unsigned smallint – whole numbers between 0 and 65535, inclusive

unsigned tinyint – whole numbers between 0 and 255, inclusive.