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

ruby-talk
1

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?

···

--
Posted via http://www.ruby-forum.com/.

2

Pen Ttt wrote:

ENCLOSED BY ' \"'

Did you intend the extra space in there?

···

--
Posted via http://www.ruby-forum.com/\.

3

Brian Candler wrote:

Pen Ttt wrote:

ENCLOSED BY ' \"'

Did you intend the extra space in there?

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

···

--
Posted via http://www.ruby-forum.com/\.