What is the difference between int(8) and int(5) in mysql?
See 12.2 Numeric Types (MySQL Reference Manual)

Essentially what you listed is the max value for INT and not BIGINT.


INT(8) is the equivalent of typing INT with a display width of 8 digits
INT(4) is the equivalent of typing just INT with 4 display lengths.


The range of BIGINT is -9223372036854775808 to 9223372036854775807 or 0 to 18446744073709551615.