Originally Posted by doubledee
Currently phpMyAdmin is set up to place the word "NULL" in any nullable fields by default, and I don't like that.
LOL! NO NO NO!
phpMyAdmin is simply *DETECTING* that the field is null and is REPORTING THAT TO YOU using the word NULL
Trust me, if phpMyAdmin was putting "NULL" into a nullable field, MySQL would barf on its feet for any field that wasn't CHAR(4) or VARCHAR(4) or larger!
How in the world do you think a field declared ad
quantity INT NULL
could *possibly* contain the *STRING* 'NULL'
?? Answer: It sure as heck can't.
You can easily prove this to yourself by, for example, doing your own SQL query (say in PHP) and then displaying the value of some null field. It will *NOT* be the string NULL