请问在Window的环境下怎么给ruby安装mysql2？

Question

我用gem install mysql2 安装rails3必须的mysql2适配器，但是总是报这个错误，请问怎么能解决？
[code="java"]
C:\Users\ZhouQiang>gem install mysql2
Building native extensions. This could take a while...
ERROR: Error installing mysql2:
ERROR: Failed to build gem native extension.

c:/Ruby192/bin/ruby.exe extconf.rb
checking for rb_thread_blocking_region()... *** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers. Check the mkmf.log file for more
details. You may need configuration options.

Provided configuration options:
--with-opt-dir
--without-opt-dir
--with-opt-include
--without-opt-include=${opt-dir}/include
--with-opt-lib
--without-opt-lib=${opt-dir}/lib
--with-make-prog
--without-make-prog
--srcdir=.
--curdir
--ruby=c:/Ruby192/bin/ruby
c:/Ruby192/lib/ruby/1.9.1/mkmf.rb:368:in try_do': The complier failed to genera
te an executable file. (RuntimeError)
You have to install development tools first.
from c:/Ruby192/lib/ruby/1.9.1/mkmf.rb:435:intry_link0'
from c:/Ruby192/lib/ruby/1.9.1/mkmf.rb:440:in try_link'
from c:/Ruby192/lib/ruby/1.9.1/mkmf.rb:552:intry_func'
from c:/Ruby192/lib/ruby/1.9.1/mkmf.rb:797:in block in have_func'
from c:/Ruby192/lib/ruby/1.9.1/mkmf.rb:693:inblock in checking_for'
from c:/Ruby192/lib/ruby/1.9.1/mkmf.rb:280:in block (2 levels) in postp
one'
from c:/Ruby192/lib/ruby/1.9.1/mkmf.rb:254:inopen'
from c:/Ruby192/lib/ruby/1.9.1/mkmf.rb:280:in block in postpone'
from c:/Ruby192/lib/ruby/1.9.1/mkmf.rb:254:inopen'
from c:/Ruby192/lib/ruby/1.9.1/mkmf.rb:276:in postpone'
from c:/Ruby192/lib/ruby/1.9.1/mkmf.rb:692:inchecking_for'
from c:/Ruby192/lib/ruby/1.9.1/mkmf.rb:796:in have_func'
from extconf.rb:9:in'

Gem files will remain installed in c:/Ruby192/lib/ruby/gems/1.9.1/gems/mysql2-0.
2.3 for inspection.
Results logged to c:/Ruby192/lib/ruby/gems/1.9.1/gems/mysql2-0.2.3/ext/mysql2/ge
m_make.out
[/code]
我看论坛上有人说这个根本就不支持windwo，那么请问有什么解决办法，暂时还没学会怎么在window下面编译gem的代码

Answer 1

在rails3环境下，用mysql照样是可以，我的gemfile:

[code="java"]gem 'mysql', :require => 'mysql'
#gem 'mysql2'[/code]