int zero in mysql

[s5jz]

Hello,

I have int (null) column in my table. Than I have php script witch sometimes inserts undefined value into that column. When I look with myphpadmin, I get 0 in that row, instead of nothing, witch I expect...

Anybody?

[Lars_Berg]

The default value (which is null by default) will only be inserted if you don't supply any value for the column in an insert statement.

So to handle this you need to check that the values are valid before inserting and return an error.

This seems to be yet another Mysql design mistake. It should not be possible to insert invalid values.

[jerdo]

This isn't a MySQL issue. In most every programming language I have ever used zero and null are pretty much the same thing.

[Lars_Berg]

It isn't in SQL.

[jerdo]

But as you can see the value he is getting is coming from PHP, in both his script and the script from phpMyAdmin.