MySQL connector for Ruby.
gem install ruby-mysql
my = Mysql.connect('mysql://username:password@hostname:port/dbname?charset=utf8mb4')
my.query("select col1, col2 from tblname").each do |col1, col2|
p col1, col2
end
stmt = my.prepare('insert into tblname (col1,col2) values (?,?)')
stmt.execute 123, 'abc'- Author: TOMITA Masahiro [email protected]
- Copyright: Copyright 2008 TOMITA Masahiro
- License: MIT