- in mysql,it can run: LOAD DATA LOCAL INFILE "/home/pt/test/bal.csv" INTO TABLE bal FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES; in my ruby programm: str="LOAD DATA LOCAL INFILE \"/home/pt/test/bal.csv\" INTO TABLE bal FIELDS TERMINATED BY ',' ENCLOSED BY ' \"' LINES TERMINATED BY '\n' IGNORE 1 LINES;" puts str dbh.query(str) the output is : LOAD DATA LOCAL INFILE "/home/pt/test/bal.csv" INTO TABLE bal FIELDS TERMINATED BY ',' ENCLOSED BY ' "' LINES TERMINATED BY '\n' IGNORE 1 LINES; /home/pt/test/ptb.rb:34:in
query': Field separator argument is not what is expected; check the manual (Mysql::Error) from /home/pt/test/ptb.rb:34:in
' what's the matter?
jeudi 2 avril 2015
how to use load command(in mysql) in ruby?
Inscription à :
Publier les commentaires (Atom)
Aucun commentaire:
Enregistrer un commentaire