Actually, if you are using SSQL you will have to apply the patch, and if you
are using them, the actual eficiency of NULL fields are a matter of design
of the program and/or the database structure..
If you are using template queries, I do it in a student's management program
i am developing, you will find them more than usefull, if not sure you can
see the MySQL Manual to look for better use of
2006/7/26, Ankur G35 Saxena <g35r...@gmail.com>:
Hi I am trying to make more efficient use of the tables that I have, since
the size seems to keep growing larger. I had my table fields to be all NOT
NULL and hence i never had to do any checking, now I am planning on using
this feature and allowing null fields in the tables. How would this affect
my fetching row values? how can I handle this? Also do you really think i
would be able to save anything with null? 90% of my fields are varchar(X)
so
if they dont have a value they will only consume 1 byte of space, so then
would it make sense for me to make the fields null?
Thanks a ton
Ankur
2 messages in com.mysql.lists.plusplusRe: How to use SQL Null while trying ...