From: "R. Mark Volkmann" <mark@...>
Date: 2005-04-03T00:28:44+09:00
Subject: [SOLUTION] MySQL under latest one-click installer

We have a winner!  A big thanks goes out to James Britt!

Here are the steps I used to use MySQL with
the Ruby Windows one-click installer (version 1.8.2-14).

  1) Download ruby-mysql-0.2.5.tar.gz
     from http://www.tmtm.org/en/ruby/mysql/README_en.html.
  2) Unzip this file.
  3) Copy mysql.rb to $RUBY_HOME\lib\ruby\1.8.

Sample code:

  require 'mysql'

  host = 'localhost'
  username = 'root'
  password = ''
  database = 'music'

  begin
    conn = Mysql.new(host, username, password, database)
    rs = conn.query('select * from artists')
    column_name = 'name'
    rs.each_hash do |row|
      puts "name = #{row[column_name]}"
    end
  rescue Mysql::Error => e
    puts "Error! #{e.err}"
  ensure
    conn.close if conn
  end

Maybe someday I'll figure out how to use the DBI API instead so my code won't be
tied to MySQL, but for now this will get me by.

--
R. Mark Volkmann
Partner, Object Computing, Inc.