Question For Load Statement

[yangkai9999]

Hello,here is my LOAD statement, but it seems doesn't work.the MySQL keep give me a '> prompt. Where is the problem?LOAD DATA LOCAL INFILE 'C:\wamp\www\MyTest2\upload\second.csv' INTO TABLE mytest.p3_new FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' ' IGNORE 1 LINES (study_id,family_id,date_visit,wbc,hgb_g_dl,hct_pctg,plt,na,k,cl,co2, Glucose,bun,cr,gfr,hdl,ldl,chol,trigl,hga1c,ma_cr,Comments); thank you,

[Synook]

You're escaping the ending inverted comma in the ESCAPED BY clause.