Re: Does a blank field take up disk space?

From: Jerry Stuckle <jstucklex_at_attglobal.net>
Date: Fri, 29 Jul 2016 11:11:53 -0400
Message-ID: <nnfrnd$rec$1_at_jstuckle.eternal-september.org>


On 7/29/2016 10:23 AM, bit-naughty_at_hotmail.com wrote:
> If I have a field, say "Price", and there has been nothing put into that field in a particular line (but there may be something in that field on *other* lines), I assume it doesn't take up space on the disk?
> (I have very little idea about what data structures MySQL uses to do its shit - what *is* it, anyway?)
>
>
> Thanks.
>

Yes, it takes up the same amount of space as the field in any other row.

Just like a variable in a program takes up memory space whether it is initialized or not.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
jstucklex_at_attglobal.net
==================
Received on Fri Jul 29 2016 - 17:11:53 CEST

Original text of this message