# Ruby sql-query good practice

**URL:** <https://www.ruby-forum.com/t/ruby-sql-query-good-practice/84143>\
**Category:** Ruby\
**Created:** [February 1, 2007, 9:14pm UTC](https://www.ruby-forum.com/t/ruby-sql-query-good-practice/84143 "2007-02-01T21:14:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rcmn](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/35a633/32.png) [@rcmn](https://www.ruby-forum.com/u/rcmn)\
**Post date:** [February 1, 2007, 9:14pm UTC](https://www.ruby-forum.com/t/ruby-sql-query-good-practice/84143/1 "2007-02-01T21:14:21Z")

</div>

what is the equivalent in ruby of that PHP code ?

\<? $sql = "select \* from mytable"; $result = mssql\_query($sql); while($row = mssql\_fetch\_array($result)){ $array[] = $row[0]; } ?\>

so far i have :

require ‘dbi’  
db = DBI.connect(“DBI:ADO:Provider=SQLOLEDB;Data  
Source=myserver;Initial Catalog=mydb;User Id=myuser;Password=;”)  
sql = db.prepare(“select\* from mytable”)  
sql.execute

while row=sql.fetch do

p row  
end

I’m just interested in a good practice to store in an array from an SQL  
query.

sql.finish

---

<div class="post-metadata">

**Author:** ![rcmn](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/35a633/32.png) [@rcmn](https://www.ruby-forum.com/u/rcmn)\
**Post date:** [February 1, 2007, 9:57pm UTC](https://www.ruby-forum.com/t/ruby-sql-query-good-practice/84143/2 "2007-02-01T21:57:07Z")

</div>

Rcmn 73 wrote:

> p row  
> end
> 
> I’m just interested in a good practice to store in an array from an SQL  
> query.
> 
> sql.finish

if you just want the first column of all rows:  
(you should probably only select that one, but anyway)

* * *

require ‘mysql’

class Mysql::Result  
include Enumerable  
end

db = Mysql::new(“myserver”, “myuser”, “”, “mydb”)

array = db.query(“SELECT \* from mytable”).map{|row| row.first}

## db.close

btw: anyone knows why the “include Enumerable” isn’t there at  
the first place?

cheers

Simon