Difference Between Integer Types in MySQL and Their Max Values

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

Continue Reading

Sliding Sidebar