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?  

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

Any help will be greatly appreciated.  

Thanks,

Ila.        Received on Wed Jun 27 15:08:52 2007