How to use load comman(in mysql) in ruby?

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 ‘"’