Re: Table: NULL (yes or no)

2004-01-05 Thread robert_rowe
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

Re: Table: NULL (yes or no)

2004-01-05 Thread Nitin Mehta
- 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

Re: Table: NULL (yes or no)

2004-01-04 Thread Mike
>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