Re: Can't get LOAD DATA INFILE to put NULL values in columns for missing CSV values

2003-07-09 Thread Paul DuBois
At 22:23 -0500 7/9/03, mos wrote: I don't know why, but if I have a CSV file with missing field values like: "ABC", I thought the missing values following the "ABC" should put NULL's in the table columns. But instead it is putting in 0's for numeric values. The table is defined to allow NUL

Can't get LOAD DATA INFILE to put NULL values in columns for missing CSV values

2003-07-09 Thread mos
I don't know why, but if I have a CSV file with missing field values like: "ABC", I thought the missing values following the "ABC" should put NULL's in the table columns. But instead it is putting in 0's for numeric values. The table is defined to allow NULL's for these columns, and the def