Snippets for using mysql in ruby

gistfile1.rb

require "mysql"

# more examples: 
# http://www.kitebird.com/articles/ruby-mysql.html

hostname = 'localhost'
username = 'yourname'
password = 'password'
database = 'mysql'
port = 3306

begin
  # connect
  db = Mysql::connect(hostname, username, password, database, port)

  sql = "select id, nickname from users limit 10"
  res = db.query(sql);
  # each hash approch
  res.each_hash do |h|
    p "#{h['id']}, #{h['nickname']}"
  end
  
  # each approach
  res2 = db.query(sql);
  res2.each do |row|
    p row.join(",")
    p row[0]
  end
  
  # Mysql::Result
  p res.class
  
  # Number of rows
  p "Number of rows: #{res.num_rows}"
  
rescue Mysql::Error => e
  p "Error message: #{e.error}, code: #{e.errno}"
ensure
  # disconnect from server
  db.close if db
end