Re: Null values are replaced with zeros in infile.

[Devart Team]

...try this one -

LOAD DATA LOCAL INFILE 'C:/orders.csv'
INTO TABLE `order`
FIELDS TERMINATED BY ','
ESCAPED BY '\'
LINES TERMINATED BY '\n' IGNORE 1 LINES
(row_id,
cust_name,
Addr,
item_name,
@var1,
@var2
)
SET order_value = IF(@var1 = '', NULL, @var1),
SET quantity = IF(@var2 = '', NULL, @var2)

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/