<snip> >> 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 >your >insert statement, the insert can not happen as the server doesn't know what >to >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 report errors. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
