List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 9 2006 11:07pm
Subject:Re: Could someone help this guy :-?
View as plain text  
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.
Thread
Could someone help this guy :-?Behrang Saeedzadeh9 Sep
  • Re: Could someone help this guy :-?Paul DuBois10 Sep
    • Re: Could someone help this guy :-?Arjan Hulshoff10 Sep