Mysql load null values from csv data

load data infile '/tmp/testdata.txt'
into table moo
fields terminated by ","
lines terminated by "\n"
(one, two, three, @vfour, five)
SET four = nullif(@vfour,'')
;

source : http://stackoverflow.com/questions/2675323/mysql-load-null-values-from-csv-data