Steven Steven - 4 months ago 47
MySQL Question

What's the Maximum Value of smallint(6) unsigned in MySQL?

What's the maximum value of

smallint(6) unsigned
in MySQL?

Answer

According to official MySQL documentation, the maximum value of an unsigned smallint is 65535.

The (6) portion has no effect on the allowed range of the column; it only affects the display of the column in the MySQL command line interface.