How many bytes of storage does a BIGINT data type hold in MySQL?
In MySQL, the BIGINT data type is a 64-bit integer that requires 8 bytes (64 bits) of storage. It is used to store large numerical values beyond the range of INT (4 bytes).
Option A (Incorrect): 1 byte corresponds to TINYINT, which can store values from -128 to 127.
Option B (Incorrect): 3 bytes is not a standard integer storage size in MySQL.
Option C (Incorrect): 4 bytes corresponds to INT, which has a range of -2,147,483,648 to 2,147,483,647.
Option D (Correct): BIGINT takes 8 bytes and supports a massive range of numbers from -2^63 to 2^63 -1.
Maryln
10 hours agoChristiane
6 days agoTalia
11 days agoAmie
16 days agoBurma
21 days agoAlise
26 days agoBlondell
1 month agoStephaine
1 month agoMerilyn
1 month agoElza
2 months agoVincent
2 months agoGoldie
2 months agoArlyne
2 months agoAnnice
2 months agoFloyd
3 months agoCallie
3 months agoStephaine
3 months agoIra
3 months agoEric
2 months ago