yangkai9999 Posted December 18, 2009 Report Share Posted December 18, 2009 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, Link to comment Share on other sites More sharing options...
Synook Posted December 20, 2009 Report Share Posted December 20, 2009 You're escaping the ending inverted comma in the ESCAPED BY clause. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now