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?
Pen T. wrote:
ENCLOSED BY ’ "’
Did you intend the extra space in there?
Brian C. wrote:
Pen T. wrote:
ENCLOSED BY ’ "’
Did you intend the extra space in there?
think you ,it must be ENCLOSED BY ‘"’