Difference Between Integer Types in MySQL and Their Max Values

D

In MySQL, there are 5 different integer types, and each type allows for different integer value sizes. In addition, each type can be signed or unsigned. If your value is always positive, then you can make your integer type unsigned.

The following table shows the values that different integer types (signed/unsigned) can hold:

Integer Type Start Value End Value
TINYINT -128 127
TINYINT (Unsigned) 0 256
SMALLINT -32,768 32,767
SMALLINT (Unsigned) 0 65,535
MEDIUMINT -8,388,608 8,388,607
MEDIUMINT (Unsigned) 0 16,777,215
INT -2,147,483,648 2,147,483,647
INT (Unsigned) 0 4,294,967,295
BIGINT -9,223,372,036,854,775,808 9,223,372,036,854,775,807
BIGINT (Unsigned) 0 18,446,744,073,709,551,615

Similar Posts:

About the author

Alvin Poh

I've over 17 years of entrepreneurship experience, having built a tech company to be the top in the country, which was subsequently acquired for an 8-figure sum. As CEO, I led the company through robust growth to 150 employees across 4 countries. After the acquisition, I embraced minimalism, sold off my personal possessions, and started living around the world.

Read more about my story here.

Add comment

By Alvin Poh

About Author

I've over 17 years of entrepreneurship experience, having built a tech company to be the top in the country, which was subsequently acquired for an 8-figure sum. As CEO, I led the company through robust growth to 150 employees across 4 countries. After the acquisition, I embraced minimalism, sold off my personal possessions, and started living around the world.

Read more about my story here.