LOAD DATA INFILE

Hi,

 

I have a question on LOAD DATA INFILE command.

I have a table with 10 columns. Is it possible to update only few
columns of this table using LOAD DATA INFILE?

 

When I tried, it updates the specified columns but other columns are set
to NULL.

 

The command that I used is

           stmt = "LOAD DATA INFILE '" + fileToLoad + "' REPLACE INTO
TABLE " +

                    tn  + " (id, value, charSet)";      

 

The result of the above action is.

| 105577247 |   NULL |      NULL |     NULL | NULL | MAILSLOTBROWSE
|       4 | NULL      |   NULL |      NULL

 

My requirement is to update only the specified columns. Is it possible
using LOAD DATA INFILE command?

 

Any help will be greatly appreciated.

 

Thanks,

Ila.