NOT NULL problems

[pradeepjain]

i ma creating a table like

create table mobile_master(id int AUTO_INCREMENT NOT NULL PRIMARY KEY,property1_name varchar(100) NOT NULL,property2_name varchar(100) NOT NULL,property3_name varchar(100) NOT NULL,property4_name varchar(100) NOT NULL,property5_name varchar(100) NULL,property6_name varchar(100) NULL,property7_name varchar(100) NULL,property8_name varchar(100) NULL,property9_name varchar(100) NULL,property10_name varchar(100) NULL,property11_name varchar(100) NULL,property12_name varchar(100) NULL,property13_name varchar(100) NULL,property14_name varchar(100) NULL,property15_name varchar(100) NULL)engine=INNODB;

but when i insert values with property2_name with no value something like this

insert into mobile_master  (property1_name,property2_name) values ('Brand','Model Number');

query gets accepted ...the NOT NULL factor is not coming into play...

[code green]

You are not inserting NULL, you are inserting an empty value.
MySql will insert the default value for a field that is NOT NULL,
0 for INT, empty for string

[pradeepjain]

is there a way so that i make sure that there is a value in a column ?

[code green]

Do you mean reject the query if there are missing values?
This is better handled on the front end.

But you could try something weird like, setting the dafault value to NULL yet have the field set to NOT NULL. No idea what would happen then.

Or write a sql function to process the incoming data that so missing data is set to NULL

Can NULLIF() be used with INSERT INTO?