NOT NULL problems

pradeepjain

i ma creating a table like

Expand|Select|Wrap|Line Numbers

 
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

Expand|Select|Wrap|Line Numbers

 
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?

NOT NULL problems

re: NOT NULL problems

re: NOT NULL problems

re: NOT NULL problems

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about