GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

load data infile "ENCLOSED BY "clause

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • load data infile "ENCLOSED BY "clause

    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 `''
Working...
X