List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:March 16 2006 6:58pm
Subject:Re: NULL columns
View as plain text  

> 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.

Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
My thoughts:
Database development questions? Check the forum!
NULL columnsfbsd_user16 Mar
  • Re: NULL columnsMartijn Tonies16 Mar
Re: NULL columnsHeikki Tuuri16 Mar