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.
Iluminada
1 month agoMalcolm
2 months agoHannah
2 months agoMicheal
2 months agoJessenia
2 months agoEna
2 months agoMatthew
2 months agoMaryln
3 months agoChristiane
3 months agoTalia
3 months agoAmie
4 months agoBurma
4 months agoAlise
4 months agoBlondell
4 months agoStephaine
4 months agoMerilyn
4 months agoElza
5 months agoVincent
5 months agoGoldie
5 months agoArlyne
5 months agoAnnice
5 months agoFloyd
6 months agoCallie
6 months agoStephaine
6 months agoIra
6 months agoRegenia
20 days agoDulce
26 days agoAmmie
1 month agoAdrianna
1 month agoEric
5 months ago