Signed and unsigned of a BIGINT

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)


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.