List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:July 11 2007 5:30am
Subject:Fwd: load data
View as plain text  
 Hi All,
We have an application where we load data on a daily basis and then do some
analysis and the move this data into different tables.

Data is comming in  files. The date format in the file  is "dd-mon-yyyy
hh24:mi:ss', but as you all know, in mysql , the default date format is
"yyyy-mm-dd hh24:mi:ss". How can i specifiy this format in the load data
infile script.

I tried this

 LOAD DATA LOCAL INFILE 'abc.txt' INTO TABLE abc FIELDS TERMINATED BY ','
LINES TERMINATED BY '^V\n' (doj timestamp "dd-mon-yyyy hh24:mi:ss");

but data is not getting inserted.

Please help me.

regards
anandkl

Thread
Fwd: load dataAnanda Kumar11 Jul