only importing one row at a time with sql loader statement

  • 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

  • the LINES TERMINATED BY IS '' ii cannot firugre out whi it only adds the first row and skips the rest

  • Try some MYSQL forum...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply