Name
BIGINT
Syntax
BIGINT[(display_size)] [AUTO_INCREMENT] [UNSIGNED] [ZEROFILL]Storage
8 bytes
Description
Largest integer type, supporting range of whole numbers from
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 (0 to
18,446,744,073,709,551,615 unsigned). BIGINT has
some issues when you perform arithmetic on unsigned values. MySQL
performs all arithmetic using signed BIGINT or
DOUBLE values. You should therefore avoid
performing any arithmetic operations on unsigned
BIGINT values greater than
9,223,372,036,854,775,807. If you do, you may end up with imprecise
results.
Get Managing & Using MySQL, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
