Last post Apr 21, 2011 10:19 AM by Dora743
Apr 21, 2011 08:47 AM|Dora743|LINK
I write a query to insert file data to a table as follows
LOAD DATA INFILE 'C:\Documents and Settings\Administrator\Desktop\Merge.txt' INTO TABLE tblachmaster
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES;
Apr 21, 2011 10:19 AM|Dora743|LINK
Resolved it is because of instead of / i used \