Integer types

Learn INT, SMALLINT, BIGINT integer types.

Integer types

SQL uses INT, SMALLINT and BIGINT for whole numbers. They differ in range and storage size.

CREATE TABLE products (
  id INT,
  stock SMALLINT,
  views BIGINT
);

INT for id, SMALLINT for small stock, BIGINT for large counts.

The table products is created.

Integer types — details

SMALLINT ranges from -32768 to 32767 and takes 2 bytes. INT gives about 2 billion range and takes 4 bytes. BIGINT is for very large numbers and takes 8 bytes.

Exercise Integer types

Create products with id INT and stock SMALLINT columns.

Show example solution

CREATE TABLE products (
  id INT,
  stock SMALLINT
)

Test yourself

Which integer type has the largest range?
- TINYINT
- INT
- SMALLINT
- BIGINT
Show answer

BIGINT — BIGINT gives the widest range.

Integer type

CREATE TABLE t (id ____);

Show answer

CREATE TABLE t (id INT);

Integer types: match the terms

INT

integer
SMALLINT

small integer
BIGINT

big integer
DECIMAL

decimal

Next lesson: Decimal types

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies