----- Original Message ----- From: "Mike" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 05, 2004 10:53 AM Subject: Re: Table: NULL (yes or no)
> > >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" > NULL > Yes, means NULL value is allowed NULL > No, means NULL value is not allowed Enjoy > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
