-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Dave Watts wrote:
>> Yup, and it'll give you the default value for that field. I >> don't see how this is a criticism. > > You're kidding, right? That defeats the entire purpose of NULL. How would > you differentiate between default values and NULLs? I think that more points to a flaw in the concept of NULLs in SQL (which, as it happens, is one of the most criticised aspects of the language) than a flaw in MySQL per-se. The real problem is that NULL is seriously overloaded in SQL. I wasn't defending MySQL's behaviour--though I can see how you could infer that--just pointing out that the real problem is elsewhere. K. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCnaDdmSWF0pzlQ04RAufZAJ9kTRt9nBg3rbHKyQ3tKbT/I8xAiACgpi7Z gwq/w3bsPZ0nIAOOqT7B/QU= =zucO -----END PGP SIGNATURE----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208171 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
