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 <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
