I usually thought INT(5) means several with a max size 5 numbers. I attempted entering a wide array within it also it in some way got cut lower to 2147483647

This clearly is not 5 numbers. What exactly does INT(5) possess a limitation of ?

From MySQL Docs, Numeric Type Attributes

MySQL supports extra time for optionally indicating the display width of integer data types in parentheses following a base keyword for that type. For instance, INT(4) identifies an INT having a display width of 4 numbers. This optional display width might be utilized by programs to show integer values getting a width under the width specified for that column by left-padding all of them with spaces. (That's, this width exists within the metadata came back with result sets. Whether it's used or otherwise can be the applying.)

INT is definitely four bytes wide. The 5 may be the "display width".

For any detailed explanation, see http://matthom.com/archive/2006/11/28/mysql-integer-columns-and-display-width


"M signifies the utmost display width for integer types. The utmost legal display width is 255. Display width is unrelated to the plethora of values a kind can contain, as referred to in Section 10.2, “Numeric Types”"

In MySQL, INT(5) does not necessarily mean that values are restricted to five-character values. It only implies that MySQL will attempt to pad these values with spaces/zeroes when coming back them.

The number selection of any signed INT including INT(10), INT(5) or other INT(n) is: -2,147,483,648 ... 2,147,483,647, that is 10 numbers for the most part.

An int could be between -2147483648 and 2147483647 signed, or and 4294967295 unsigned.

For this reason it had been cut lower to that particular should you joined several bigger of computer like a signed value