Re: LOAD DATA INFILE from csv file

[Sachin G]

Hi Barry,

Thank you for the reply. It worked. Below is my query as per suggestion.

LOAD DATA INFILE 'C:\\Share\\Results\\ResultsData.csv'
INTO TABLE test.results
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(column1, column2, @col3, column4 ...)
SET column3 = STR_TO_DATE(@col3,'%m/%d/%Y %H:%i');

I only need to change the hr format. Thanks again.

Sachin