require 'rubygems' require 'mysql'
begin
dbh = Mysql.real_connect("localhost", "root", "", "book",3306)
res = dbh.query("SELECT * FROM books")
puts "========\n"
while row = res.fetch_row do
printf "%s, %s\n", row[1], row[2]
end
puts "========\n"
puts "Server version: " + dbh.get_server_info
rescue Mysql::Error => e
puts "Error code: #{e.errno}"
puts "Error message: #{e.error}"
puts "Error SQLSTATE: #{e.sqlstate}" if e.respond_to?("sqlstate")
ensure
dbh.close if dbh
end