Skip to main content

Numeric Types: INT, BIGINT, SMALLINT & TINYINT

Learn Numeric Types: INT, BIGINT, SMALLINT & TINYINT (Data Types, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction Integer types differ in storage and range: TINYINT 1 byte (-128..127), SMALLINT 2 (-32768..32767), MEDIUMINT 3, INT 4 (about +-2.1 billion), BIGINT 8 (about +-9.2e18). Add UNSIGNED to double the positive range.

More lessons in Data Types