Re: Does a blank field take up disk space?
From: Jerry Stuckle <jstucklex_at_attglobal.net>
Date: Fri, 29 Jul 2016 14:19:06 -0400
Message-ID: <nng6md$49q$1_at_jstuckle.eternal-september.org>
>
> From the second link:
> "And the row is shorter because the NULLs take no space. " - that seems to conflict with what Jerry Stuckle is saying....?
>
Date: Fri, 29 Jul 2016 14:19:06 -0400
Message-ID: <nng6md$49q$1_at_jstuckle.eternal-september.org>
On 7/29/2016 1:06 PM, bit-naughty_at_hotmail.com wrote:
> On Friday, July 29, 2016 at 9:14:57 PM UTC+5:30, The Natural Philosopher wrote:
>>> >> https://dev.mysql.com/doc/internals/en/myisam-introduction.html >> https://dev.mysql.com/doc/internals/en/innodb-field-contents.html
>
> From the second link:
> "And the row is shorter because the NULLs take no space. " - that seems to conflict with what Jerry Stuckle is saying....?
>
That is true for a VARCHAR field - but not fixed length fields. You asked about PRICE - which would typically be a numeric field, not VARCHAR.
-- ================== Remove the "x" from my email address Jerry Stuckle jstucklex_at_attglobal.net ==================Received on Fri Jul 29 2016 - 20:19:06 CEST