Jump to content

Question For Load Statement


Recommended Posts

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...