On Fri, Feb 07, 2003 at 04:33:15PM -0700, [EMAIL PROTECTED] wrote:
Hi Doug Beyer [EMAIL PROTECTED],
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
Please could these stop. Already I have noticed various people
reposting old
/doc/en/SHOW.html
* http://www.mysql.com/doc/en/SHOW_CREATE_TABLE.html
* http://www.mysql.com/doc/en/ODBC_administrator.html
This was an automated response to your email 'CREATE TABLE, NOT NULL fields, and empty
strings'.
Final search keyword used to query the manual was 'CREATE TABLE
Doug Beyer wrote:
create table t1 ( id varchar(5) not null, name varchar(5) not null );
insert into t1 ( id ) values ( 1234 );
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
Doug,
create table t1 ( id varchar(5) not null, name varchar(5) not null );
insert into t1 ( id ) values ( 1234 );
select count(*) from t1 where name = ;-- Result = 1
1) Why did the insert succeed since the name field is not null and I didn't
provide a value?
2) Why does
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: