MySql Accept null in fields althought I set it to be not null?

[saidbakr]

I have mySQL Ver 3.23.52, The problem is, It accept Null values in fields that I have defined it to do not
accept NUll, Like this example
ALTER TABLE personnel CHANGE firstname firstname VARCHAR( 25 ) NOT NULL
Then it accept the following insert record Althogh All fields was set to be not Null

INSERT INTO personnel ( id , firstname , lastname , nick , email , salary )
VALUES (
'', '', '', '', '', '0'
);
So Why this's happen?! And what's the solution?😕

[bretticus]

Well, the problem is it's not really null in your insert field, it's an empty string and that's different. Now if you just excluded firstname from your insert query command, that woudl give you an error with mysql. Or if you had:

INSERT INTO personnel ( id , firstname , lastname , nick , email , salary )
VALUES (
'', null, '', '', '', '0'
);