09/05/11 02:54:33
>>250
#!/usr/bin/ruby
require "dbi"
DBI.connect("dbi:Mysql:test:localhost", "root", "password") do |dbh|
dbh.execute("SELECT * FROM tbl_employee WHERE dpt_code <> 10") do |sth|
puts sth.fetch_all.select{|row| row[0] == 104}.join("¥n")
end
end