Steven
Reputation: 25304
What's the Maximum Value of smallint(6) unsigned in MySQL?
What's the maximum value of smallint(6) unsigned in MySQL?
Upvotes: 30
Views: 45983
Answers (2)
longneck
Reputation: 12226
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.
Upvotes: 58
Related Questions
- What is the maximum value of unsigned DECIMAL(M, D) column?
- Is BIGINT(8) the largest integer MySQL can store?
- MySQL TINYINT as unsigned
- What is the MAX number if I store int(255) in MySQL?
- MySQL Boolean "tinyint(1)" holds values up to 127?
- What is maximum value for tinyint(2) in MySQL?
- Mysql datatype for single digit - tinyint(1) or smallint(1) or int(1)
- what is the max limit of mysql int 11?
- How to understand if a bigint is signed or unsigned in mysql?
- Why can't tinyint store more than the number 255 in MySQL?