Behrang Saeedzadeh wrote:
Hi,

Could someone help this guy work around this problem in MySQL:
http://www.redhillconsulting.com.au/blogs/simon/archives/000347.html

I think the answer to his questions lies in the manual:

http://dev.mysql.com/doc/refman/5.0/en/data-type-defaults.html

If a column is NOT NULL and contains no DEFAULT clause in its
definition, the default is the implicit default for the column's
data type.

That's with strict mode disabled; in strict mode, columns with no
DEFAULT clause must be given a value.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to