, November 01, 2003 05:13
To: Jan Magnusson
Cc: Mysql General mailing list
Subject: Re: not null and default values confusion
Jan,
This question comes up a lot. You should take a look at
http://www.mysql.com/doc/en/constraint_NOT_NULL.html. The first line
is, To be able to support easy handling
Hi,
This question comes up a lot. You should take a look at
http://www.mysql.com/doc/en/constraint_NOT_NULL.html. The first line
is, To be able to support easy handling of non-transactional tables,
all fields in MySQL have default values. Mysql automatically converts
missing or illegal
Dear List,
Could sombody explain this behaviour of mySQL 4 to me:
Assigning a column as not null will AUTOMATICALLY assign (=force upon) it
a default value of an empty string ('') if a string or zero (0) if a
numerical datatype. Thereby effectively bypassing all and every error
message during
Jan,
This question comes up a lot. You should take a look at
http://www.mysql.com/doc/en/constraint_NOT_NULL.html. The first line
is, To be able to support easy handling of non-transactional tables,
all fields in MySQL have default values. Mysql automatically converts
missing or illegal