require 'mysql'
m = Mysql.new("localhost","pannuo","pannuo","pannuo")#分别为主机地址,用户名,密码,数据库
r= m.query("SELECT NAME,ACTIVE FROM pannuo.SYS_USER S LIMIT 0,1000 ")
r.each_hash do |f|
print "#{f['NAME']}-#{f['ACTIVE']} "
end
错误
:
coding/NetBeans/TestRuby/lib/dataTest.rb:4:in `require': no such file to load -- mysql (LoadError)
from coding/NetBeans/TestRuby/lib/dataTest.rb:4:in `<main>'