I've got some numbers that is now larger than INT
can handle.
This is a bit embarrassing, but I honestly don't know exactly what the BIGINT(8)
means. Is the 8 in that the max bit value or the max length?
So BIGINT(1)
can only be one digit? Or is BIGINT(1)
something else? I think TINYINT(1)
max is 127, how does that work out?
- What is the biggest I can make
BIGINT
? - What is the largest number I can store in MySQL as an integer?