The column types supported by MySQL are listed below. The following code letters are used in the descriptions: 

M - Indicates the maximum display size. The maximum legal display size is  255 . 
D - Applies to floating-point types and indicates the number of digits following the decimal point. The maximum possible value is  30 , but should be no greater than M- 2 . 
Square brackets (`[' and `]') indicate parts of type specifiers that are optional.

INT[(M)] [UNSIGNED] [ZEROFILL] 
A normal-size integer. The signed range is - 2147483648  to  2147483647 . The unsigned range is  0  to  4294967295 .

When asked to store a value in a numeric column that is outside the column type's allowable range, MySQL clips the value to the appropriate endpoint of the range and stores the resulting value instead. 

For example, the range of an INT column is -2147483648 to 2147483647. If you try to insert -9999999999 into an INT column, the value is clipped to the lower endpoint of the range, and -2147483648 is stored instead. Similarly, if you try to insert 9999999999, 2147483647 is stored instead. 

If the INT column is UNSIGNED, the size of the column's range is the same but its endpoints shift up to  0  and  4294967295 . If you try to store - 9999999999  and  9999999999 , the values stored in the column become  0  and  4294967296