INSERTing NULL versus '0' in numeric fields

[rhyno2k]

Hi,


My PHP application does a mass INSERT of about 3 dozen fields, many of
them numeric. After I run the INSERT, however, MySQL places a bunch
of "0"s (zeroes) in every numeric field, even if a null value was
passed.

I don't want to convert these fields to VARCHARs... so can I:
- force a NULL insert
- change default NULL insert behavior (i.e. don't put a 0 in!)
or
- easily run a post-INSERT one-line SQL statement to change all "0"
field values to null?

(MySQL 4.1.7)


Thanks,
--RHYNO

 

[r937]

if you want NULL in the column when you insert a NULL, then the column needs to be defined as NULL

you've probably defined it as NOT NULL DEFAULT 0



r937.com | rudy.ca