At 16:23 -0500 4/4/03, <mapa...@epix.net> 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) UNSIGNED DEFAULT '0' NOT NULL
AUTO_INCREMENT, `name` VARCHAR (30) NOT NULL, `place` CHAR (30),
PRIMARY KEY(`ID`), UNIQUE(`ID`), INDEX(`ID`));
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 nuts?
I don't know if you're nuts or not, but NULL and the empty string are
very definitely not the same thing.
INSERT INTO TableName (ID, name, place) VALUES (NULL, NULL, NULL);
gives me and error which is what I want
but
INSERT INTO TableName (ID, name, place) VALUES (NULL, '', NULL);
goes without any problem and i thought it should return and error also
It won't, because '' is different than NULL.
thanks for any help or comments
,Michael
4 messages in com.mysql.lists.mysqlRe: Not Null isn't working or am I wrong
