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

**URL:** <https://www.ruby-forum.com/t/how-to-use-load-comman-in-mysql-in-ruby/187972>\
**Category:** Ruby\
**Created:** [May 3, 2010, 3:38pm UTC](https://www.ruby-forum.com/t/how-to-use-load-comman-in-mysql-in-ruby/187972 "2010-05-03T15:38:02Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![luofeiyu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/9de0a6/32.png) [@luofeiyu](https://www.ruby-forum.com/u/luofeiyu)\
**Post date:** [May 3, 2010, 3:38pm UTC](https://www.ruby-forum.com/t/how-to-use-load-comman-in-mysql-in-ruby/187972/1 "2010-05-03T15:38:02Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![luofeiyu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/9de0a6/32.png) [@luofeiyu](https://www.ruby-forum.com/u/luofeiyu)\
**Post date:** [May 4, 2010, 12:37pm UTC](https://www.ruby-forum.com/t/how-to-use-load-comman-in-mysql-in-ruby/187972/2 "2010-05-04T12:37:07Z")

</div>

Pen T. wrote:

> ENCLOSED BY ’ "’

Did you intend the extra space in there?

---

<div class="post-metadata">

**Author:** ![luofeiyu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/9de0a6/32.png) [@luofeiyu](https://www.ruby-forum.com/u/luofeiyu)\
**Post date:** [May 5, 2010, 3:39pm UTC](https://www.ruby-forum.com/t/how-to-use-load-comman-in-mysql-in-ruby/187972/3 "2010-05-05T15:39:11Z")

</div>

Brian C. wrote:

> Pen T. wrote:
> 
> > ENCLOSED BY ’ "’
> 
> Did you intend the extra space in there?

think you ,it must be ENCLOSED BY ‘"’