1-- SIGNED UNSIGNED
2-- Min Max Min Max
3TINYINT -128 127 0 255
4SMALLINT -32767 32767 0 65535
5MEDIUMINT -8388608 388608 0 16777215
6INT -2147483648 2147483647 0 4294967295
7INTEGER -2147483648 2147483647 0 4294967295
8BIGINT -9223372036854775808 9223372036854775808 0 18446744073709551615
1For MySQL database:
2In BIGINT(8), the number 8 represents how the data will be displayed. It does not affect the storage. The number is used to display width.
3
4BIGINT takes 8 bytes i.e. 64 bits. The signed range is -9223372036854775808 to 9223372036854775807 and unsigned range takes positive value. The range of unsigned is 0 to 18446744073709551615.