Mysql bigint max value

--			SIGNED										  UNSIGNED
--			Min               		Max                   Min Max
TINYINT     -128                    127                   0   255
SMALLINT    -32767                  32767                 0   65535
MEDIUMINT   -8388608                388608                0   16777215
INT         -2147483648             2147483647            0   4294967295
INTEGER     -2147483648             2147483647            0   4294967295
BIGINT      -9223372036854775808    9223372036854775808   0   18446744073709551615

Source: techonthenet.com

Mysql biginteger size

For MySQL database:
In 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.

BIGINT 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.

Similar codes

0 vote167 views1 answer
Add week ending date sql server
SQL
11 votes126 views1 answer
Creating tables in sql with python
SQL
26 votes114 views2 answers
What is the sql statement that finds duplicate usernames
SQL
1 vote120 views3 answers
Psql fatal database does not exist
SQL
0 vote109 views1 answer
Min mysql
SQL
1 vote68 views1 answer
Full text index mysql
SQL
2 votes126 views1 answer
Postgresql create table as select
SQL
0 vote121 views1 answer
Insert overwrite table in mysql in nifi
SQL
0 vote121 views1 answer
Modifier une valeur sql
SQL
6 votes139 views2 answers
Clear a table in mysql
SQL