-
The best datatype for a column that is expected to store values up to 2 million is _________.
-
- BIGINT
- MEDIUMINT
- TINYINT
- SMALLINT
- None of these
Correct Option: A
The different numeric types used in MySQL are used to store different range of values. To store values of the order of a million, the MEDIUMINT or BIGINT datatype is sufficient.