Difference Between Integer Types in MySQL and Their Max Values

Share on facebook
Facebook
Share on google
Google+
Share on twitter
Twitter
Share on linkedin
LinkedIn

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:

More to explorer

how i started being a minimalist

How I Started Being A Minimalist

Once, I thought that all that mattered in life were the things that you possessed. Things like your car, house, watch, clothes.

Leave a Reply

Your email address will not be published. Required fields are marked *