>I create two tables. And when I do >desc table_name; >NULL value can be 'Yes' or 'No'. What the difference when NULL >value is 'Yes' or 'No"
Not sure what you are asking, but if you have an ENUM column that can be Yes or No and you do not set the column to NOT NULL then there are three possible values: Yes, No, and NULL. NULL simply means no value. Sometimes it is appropriate, sometimes it is not. In the case of a Yes/No ENUM column I would say that in most cases the column should be set NOT NULL. Regards, Mike Hillyer www.vbmysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]