This is the MySQL API module for Ruby. It provides the same functions for Ruby programs that the MySQL C API provides for C programs.
- MySQL >= 5.5 && < 8.0
- Ruby >= 2.2
Add this line to your application's Gemfile:
gem 'mysql'And then execute:
% bundle
Or install it yourself as:
% gem install mysql -- --with-mysql-dir=/usr/local/mysql
available options:
| option | description |
|---|---|
--with-mysql-include=dir |
MySQL header file directory (default: /usr/local/include) |
--with-mysql-lib=dir |
MySQL library directory (default: /usr/local/lib) |
--with-mysql-dir=dir |
Same as --with-mysql-include=dir/include --with-mysql-lib=dir/lib |
--with-mysql-config[=/path/to/mysql_config] |
Get compile-parameter from mysql_config command |
install:
% make install
require 'mysql'
my = Mysql.new(host, user, passwd, database, port)
my.query('insert into ...')
my.query('select ...') do |res|
...
endcompile:
% ruby extconf.rb --with-mysql-dir=/usr/local/mysql
test:
% ruby ./test.rb -- hostname user passwd dbname port socket flag
If you get error like 'libmysqlclient not found' when testing, you need to specify the directory in which the library is located so that make can find it.
% env LD_RUN_PATH=[libmysqlclient.so directory] make
TOMITA Masahiro @tmtms