LMSouq
database Open

Types in MySQL: BigInt(20) vs Int(20)

PA
Parris
1 month ago
3 views
Problem Description
I was wondering what the difference between `BigInt`, `MediumInt`, and `Int` are... it would seem obvious that they would allow for larger numbers; however, I can make an `Int(20)` or a `BigInt(20)` and that would make seem that it is not necessarily about size. Some insight would be awesome, just kind of curious. I have been using **MySQL** for a while and trying to apply business needs when choosing types, but I never understood this aspect.

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base