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