The INT Designation can be followed by Arguments that enhance the criteria around how the value will be stored
Data Type |
Original Value |
Value Stored |
Value Displayed |
INT |
99 |
99 |
99 |
INT |
-99 |
-99 |
-99 |
INT UNSIGNED |
99 |
99 |
99 |
INT UNSIGNED |
-99 |
None |
None |
INT ZEROFILL |
99 |
99 |
0000000099 |
INT(4) ZEROFILL |
99 |
99 |
0099 |
INT Attributes UNSIGNED And ZEROFILL