> When doing an insert using NULL in the insert request,
> what really is being written in the column?
> Is the word NULL being written?
> Is any real space being consumed?
In the cases that you really want to store NULL ;-)
No, it's not the word "null".
Of course space is consumed.
How much depends, see, for example:
This is for MyISAM, InnoDB behaves differently.
Database Workbench - development tool for MySQL, and more!
Database development questions? Check the forum!