Null means "no data entered". If Null is allowed and you don't specifically set a
field to a value then it will be Null. If Null is not allowed then the field will be
assigned its default value unless you specifically set it to something during an
insert.
--
MySQL General Mailing List
For lis
- 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 b
>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 possibl