Re: Not Null isn't working or am I wrong

Paul DuBois wrote: At 16:23 -0500 4/4/03, <[EMAIL PROTECTED]> wrote: Now when i put data into the table i can't have all blanks which is right. When i put data into the field that allows nulls the not null one gets '' as its data and goes on. I though NULL and '' were the same thing. Am i n

Re: Not Null isn't working or am I wrong

At 16:23 -0500 4/4/03, <[EMAIL PROTECTED]> wrote: Hi everyone, When creating a table I have a autonumber primary key, a varchar(30) field that is not null and another field that not null is not selected. Here is the table creation command i used. CREATE TABLE `TableName` (`ID` INT (3) UNSI

Not Null isn't working or am I wrong

Hi everyone, When creating a table I have a autonumber primary key, a varchar(30) field that is not null and another field that not null is not selected. Here is the table creation command i used. CREATE TABLE `TableName` (`ID` INT (3) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT, `name`