Ruby connection to MySQL

First install ruby1.8.6
Then go
Http://rubyforge.org/projects/mysql-win
Download mysql-2.7.3-mswin32.gem
In command line mode (if the environment variable is not set, you can directly switch to the bin directory under the ruby installation directory)
Gem install E:/tddownload/mysql-2.7.3-mswin32.gem

Then put such as D:/Ruby/lib/Ruby/gems/1.8/gems/mysql-2.7.3-mswin32/EXT
MySQL. So
Put it under a i386-msvcrt such as D:/Ruby/lib/Ruby/site_ruby/1.8/
Copy libmysql. dll in the bin directory under the MySQL installation directory to, for example, D:/Ruby/bin.

Require "MySQL"
DBC = mysql. real_connect ('localhost', 'root', '*******', 'mytest ')
Res = DBC. Query ('select ID from test ')
While ROW = res. fetch_row do
Puts "# {row [0]}"
End

Test successful
I have uploaded mysql-2.7.3-mswin32.gem
Now