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 `''
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 `''