I attempted to search various places for my answer but with no luck. So I'm posting here.
I create the following table: create table t1 ( id varchar(5) not null, name varchar(5) not null ); I insert the following row: insert into t1 ( id ) values ( "1234" ); I do the following selects: select count(*) from t1 where name is null; --> Result = 0 select count(*) from t1 where name = ""; --> Result = 1 Questions: 1) Why did the insert succeed since the "name" field is not null and I didn't provide a value? 2) Why does MySql think it's correct to substitute an empty string for a non-provided value? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
