What is the best datatype for a column that is expected to store values up to 2 million?
(a) SMALLINT
(b) TINYINT
(c) MEDIUMINT
(d) BIGINT
(a) SMALLINT
(b) TINYINT
(c) MEDIUMINT
(d) BIGINT
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
Right option is (d) BIGINT
For explanation I would say: The different numeric types used in MySQL are used to store a different range of values. To store values of the order of a million, the MEDIUMINT or BIGINT datatype is sufficient.