Sql select : Mysql « Database « Ruby

1. Ruby
2. Database
3. Mysql

Sql select

require 'mysql'

m = Mysql.new("localhost","ruby","secret","maillist")
r = m.query("SELECT * FROM people ORDER BY name")
r.each_hash do |f|
  print "#{f['name']} - #{f['email']}"
end

 

Related examples in the same category