.
| Type | Length in Bytes |
Minimum Value (Signed) |
Maximum Value (Signed) |
Minimum Value (Unsigned) |
Maximum Value (Unsigned) |
|---|---|---|---|---|---|
| TINYINT | 1 | -128 | 127 | 0 | 255 |
| SMALLINT | 2 | -32768 | 32767 | 0 | 65535 |
| MEDIUMINT | 3 | -8388608 | 8388607 to | 0 | 16777215 |
| INT | 4 | -2147483648 | 2147483647 | 0 | 4294967295 |
| BIGINT | 8 | -9223372036854775808 | 92233720368 54775807 |
0 | 184467440737 09551615 |
Try It Now
Signed variables, such as signed integers will allow you to represent numbers both in the positive and negative ranges.
Unsigned variables, such as unsigned integers, will only allow you to represent numbers in the positive.
ZEROFILL
INT(5) ZEROFILL with the stored value of 32 will show 00032 INT(5) with the stored value of 32 will show 32 INT with the stored value of 32 will show 32