When I change the content of VARCHAR(32) from 32 chars to 0, will it save some space?
The reason I'm asking it is because I store a hash of 32 chars to check something but after a while I'll not use it anymore, so if it takes some of DB space, I might change this field to empty ''
.
According to the manual, it takes 1b
plus the chars for strings with 255 chars or less, but what if we already have some data and change it to empty, does it save some space?
I'm currently using MySQL with InnoDB engine.
PS.: I'm a beginner yet, please bare with me.
null
orempty string
in all rows. – William Aug 17 '16 at 12:57