List:General Discussion« Previous MessageNext Message »
From:Keith C. Ivey Date:April 14 2004 3:33pm
Subject:Re: NOT NULL column behaves strangely
View as plain text  
On 14 Apr 2004 at 17:27, B. Fongo wrote:

> I expected a warning because of the Token column shouldn't be NULL! 

It's not NULL.  It's the empty string, which is the default value, 
since you didn't give it a specific default value.  See the "CREATE 
TABLE" documentation:

    If no DEFAULT value is specified for a column, MySQL
    automatically assigns one, as follows. If the column can
    take NULL as a value, the default value is NULL. If the
    column is declared as NOT NULL, the default value depends on
    the column type: 
    [...]
    * For string types other than ENUM, the default value is the
    empty string.

http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html

-- 
Keith C. Ivey <keith@stripped>
Tobacco Documents Online
http://tobaccodocuments.org

Thread
NOT NULL column behaves strangelyB. Fongo14 Apr
  • Re: NOT NULL column behaves strangelyKeith C. Ivey14 Apr
    • Re: NOT NULL column behaves strangelyRuslan U. Zakirov14 Apr
      • Re: NOT NULL column behaves strangelyMichael Stassen14 Apr
        • AW: NOT NULL column behaves strangelyB. Fongo14 Apr
  • Re: NOT NULL column behaves strangelyMartijn Tonies14 Apr
    • AW: NOT NULL column behaves strangelyB. Fongo14 Apr