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
I didn't know this too I expect correct behavior: error. So if I want error on such INSERTs I must use 'IS NOT NULL default NULL'?
Best regards. Ruslan.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]