I just tried entering NULL into an INT field a DECIMAL field and a FLOAT
field and the contents were always NULL.
You will most likely find that the field is set up with a default value of 0
and it may also be defined as not null.
You can change these settings with an ALTER TABLE command