MYSQL LOAD DATA INFILE

Question

I use LOAD DATA INFILE in mysql. In my input file I have "x" character but I have to save it to database as NULL. How can I do it?

Answer 1

load data infile... 
into table ...
fields terminated by...
lines terminated by ...
(
 my_field...
)
set 
my_field = if(my_field = 'x', null, my_field);