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

Site Footer

Sliding Sidebar


The contents on this blog are not intended as professional advice. The author disclaims any liability, loss, or risk taken by individuals who directly or indirectly act on the information contained on this blog.