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.
Malcolm
1 day agoHannah
6 days agoMicheal
11 days agoJessenia
17 days agoEna
22 days agoMatthew
27 days agoMaryln
2 months agoChristiane
2 months agoTalia
2 months agoAmie
2 months agoBurma
2 months agoAlise
2 months agoBlondell
3 months agoStephaine
3 months agoMerilyn
3 months agoElza
3 months agoVincent
3 months agoGoldie
3 months agoArlyne
4 months agoAnnice
4 months agoFloyd
4 months agoCallie
4 months agoStephaine
5 months agoIra
5 months agoEric
4 months ago