Hi Friends,
I have problem in load data infile ENCLOSED BY clause. Can anyone suggest solution to my following problem:
I m running the following command :
LOAD DATA INFILE ‘myfile’
INTO TABLE TB_MRR
FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘"’
IGNORE 1 LINES
;"
on running the above command the error encounterd is as follows:
unexpected EOF while looking for matching `’’