Hello,
I am trying to load a small table with some log data. The data has a date column with the format dd-mon-yy.
I use the following script to load the data into the table.

LOAD DATA INFILE ‘/home/data/20100202/campaign_4233.log’ INTO TABLE campaigns CHARACTER SET latin1
              FIELDS TERMINATED BY ‘^’
      (advertiser_id,buy_id,buy,@start_date,@end_date,creative_library_enabled)
          set start_date = str_to_date(‘01-SEP-06’,’%d-%M-%y’),
              end_date = str_to_date(‘01-SEP-06’,’%d-%M-%y’);

The data load goes through but the date columns are not being filled.
Can someone help me on this?

Regards
Sumit

Hi Sumit,

Actually the Infobright loader does not support embedded functions. You can read about the capabilities of the loader in the data loading guide available on the downloads page.

If you need additional features, IEE comes with the MySQL loader and is available for a 14 day trial .

Regards, Bob