'NULL in compact row format in mysql?
The size of the null value list is one byte in mysql Innodb with compact row format. If there are many columns with null values, won't they overflow.
Solution 1:[1]
I am not sure I understand the question. but a NULL value is not an empty string and it's also not an empty value/number. it takes zero space. so having millions of null values or just one. it's exactly the same thing.
I guess if I were to imagine null to a real-world example, I would imagine nothing. since null means something that's not there. even when you close your eyes, you basically see darkness. with null darkness is not there.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Demeteor |