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]