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

[Pen Ttt]

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 `<main>'
what's the matter?

 

[Brian Candler]

ENCLOSED BY ' \"'

Did you intend the extra space in there?

 

[Pen Ttt]

Did you intend the extra space in there?

think you ,it must be ENCLOSED BY '\"'