Is BIGINT(8) the largest integer MySQL can store?

Viewed 69863

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?
5 Answers
Related