MySQL Performance: MySQL => load data infile "ENCLOSED BY "clause

Members

Help

Home

Home » Performance » MySQL » load data infile "ENCLOSED BY "clause

Show: Today's Messages :: Show Polls :: Message Navigator

load data infile "ENCLOSED BY "clause [message #3429]

Thu, 14 August 2008 02:31

sudhir
Messages: 4
Registered: August 2008

Junior Member

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

[Updated on: Thu, 14 August 2008 02:35]

Report message to a moderator

Previous Topic:	Why split table got worse performance
Next Topic:	Need some help with select datetime range performance

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 5 11:05:34 EST 2008

Total time taken to generate the page: 0.01877 seconds

.:: Contact :: Home :: MySQL Support by Percona.com ::.