Re: "not null" and default values confusion

Hi, > This question comes up a lot. You should take a look at > . 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 il

RE: "not null" and default values confusion

o:[EMAIL PROTECTED] > Sent: Saturday, 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.m

Re: "not null" and default values confusion

Jan, This question comes up a lot. You should take a look at . 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

"not null" and default values confusion

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