#!/usr/local/bin/ruby-Ke require 'mysql' object = Mysql::new('localhost','ユーザー名','パスワード') object.create_db("TEST_RUBY") object.close object = Mysql::new('localhost','ユーザー名','パスワード','TEST_RUBY') object.query('create table test_table (name char(32),price int)') object.query("insert into test_table values ('りんご',300);") object.query("insert into test_table values ('みかん',80);") object.query("insert into test_table values ('梨',150);") object.query("insert into test_table values ('桃',250);") object.query("insert into test_table values ('メロン',3450);") object.query("insert into test_table values ('いちご',450);") puts object.list_dbs().join(",") puts object.server_info() puts object.host_info() i= object.list_fields('test_table').num_fields() for count in 0..i-1 field_object = object.list_fields('test_table').fetch_field_direct(count) puts field_object.name end field_object = object.list_fields('test_table').fetch_field_direct(0) puts field_object.name puts field_object.table puts field_object.def puts field_object.type puts field_object.length object.close