> 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:
http://dev.mysql.com/doc/refman/5.0/en/static-format.html
or
http://dev.mysql.com/doc/refman/5.0/en/dynamic-format.html
This is for MyISAM, InnoDB behaves differently.
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]