From: Derek Smith <derekbellnersmith@...>
Date: 2009-07-30T11:31:35+09:00
Subject: inserting into sqlite3

I have a text file, called maillog that I want to insert into a table.
My pseudo-code is

open mail file
connect to database => 'require dbi' here?
create table for maillog data
create primary key in table

for each line in mailfile
do
    insert line from mailfile into rows
done

close file
close database


Am I far off?
Please advise with tips maybe and or actual code!
Thank you
-- 
Posted via http://www.ruby-forum.com/.