Create a table:
mysql> create table DemoTable
(
Number bigint, // signed
Number2 bigint unsigned // unsigned
);
Query OK, 0 rows affected (1.08 sec)
Insert records in the table:
mysql> insert into DemoTable values(18446744073709551615,18446744073709551615);
ERROR 1264 (22003): Out of range value for column 'Number' at row 1
mysql> insert into DemoTable values(9223372036854775807,18446744073709551615);
Query OK, 1 row affected (0.28 sec)
Display all records from the table:
mysql> select * from DemoTable;
The output:
+---------------------+----------------------+
| Number | Number2 |
+---------------------+----------------------+
| 9223372036854775807 | 18446744073709551615 |
+---------------------+----------------------+
1 row in set (0.00 sec)
Conclusion
BIGINT is a large integer. The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615.
If a column has been set to ZEROFILL, all values will be prepended by zeros so that the BIGINT value contains a number of M digits.
Note: If the ZEROFILL attribute has been specified, the column will automatically become UNSIGNED.
Reference: https://mariadb.com/kb/en/bigint