only importing one row at a time with sql loader statement

• poagola

  SSC Enthusiast

  Points: 186

  More actions

  June 4, 2012 at 3:44 pm

  #256945

  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

• poagola

  SSC Enthusiast

  Points: 186

  More actions

  June 4, 2012 at 3:45 pm

  #1496807

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

• Eugene Elutin

  SSC Guru

  Points: 59322

  More actions

  June 6, 2012 at 7:04 am

  #1497599

  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]