>> If that's all you did, you indeed 'removed the default NULL' but did not
>specify another default. Hence, if you don't explicitly specify a value in
>insert statement, the insert can not happen as the server doesn't know what
>put there and is explicitly disallowed from leaving the value empty.
> That makes sense. So then why does phpMyAdmin allow you to choose "None"
>as a default?
[JS] There are times when you want to enforce certain conditions even though
they might sometimes generate an error. Two examples are required fields (no
default value) or referential integrity.
The goal is not to lose data, but to make sure your applications are doing
what they are supposed to do. You would program your applications to trap and
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
Web site: www.the-infoshop.com