Steven Steven - 1 year ago 304
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 Source

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download