ruby连接mysql数据库

1.连接数据库

require "mysql"

dbc = Mysql.real_connect('127.0.0.1','root','123','test)

res = dbc.query('select * from users')

while row = res.fetch_row do

          puts "#{row[0]},#{row[1]}"

end

my = Mysql::new('127.0.0.1',userName,'',pwd)

res = my.query("select * from tbl_name")

res.each do |row|

  col1 = row[0]

  col2 = row[1]

  puts "#{col1}"

  puts "#{col2}"

end

puts my.affected_rows() => 2

#create_db(xggTest)

puts my.get_host_info()  => 127.0.0.1 via TCP/IP

puts my.field_count() => 4

puts my.ping()  => #<Mysql:0x3527070>