First page Back Continue Last page Overview Graphics
Insert data
- require "dbi"
sql = "INSERT INTO request(host, url) VALUES(?, ?)"
DBI.connect("DBI:Mysql:logs", "user", "pass") { |conn|
conn.prepare(sql) { |query|
loop {
data = STDIN.readline.split or break
query.execute(data[0], data[1])
}
}
}