June 4, 2012 at 3:44 pm
LOAD DATA LOCAL INFILE 'C:\\Documents and Settings\\J03299\\Desktop\\TMETER.csv'
INTO TABLE edata
COLUMNS TERMINATED BY ',' ENCLOSED BY "" LINES TERMINATED BY ''
(Year,Month,Day,MJD,xpiles,xstacks,Utilites);
above is the script i am attempting to run to load 7 columns from a csv file into a mysql database. I am able to read the first row well but it skips and jumps to the 154 row for some reason. my data is arranged as follows
2012, 6, 10, 56079, 0.0470, 0.3964, -0.57386,
2012, 6, 20, 56080, 0.0479, 0.3967, -0.57502,
i cannot understand why it cannot read all the rows and insert them into mysql. i have the line delimiter as ''. please assist
June 4, 2012 at 3:45 pm
the LINES TERMINATED BY IS '' ii cannot firugre out whi it only adds the first row and skips the rest
June 6, 2012 at 7:04 am
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy