Ruby & MySQL
548 ワード
require "rubygems"
require 'mysql'
db = Mysql.connect('localhost', 'root','******','ruby')
db.query("insert into people values(null,' ',22)")
begin
query = db.query('select * from people')
puts "There were #{query.num_rows} rows returned"
query.each_hash do |h|
puts h.inspect
end
rescue
puts db.errno
puts db.error
end
db.close