SQLite output to csv
sqlite> .mode csv sqlite> .output test.csv sqlite> select * from tbl1; sqlite> .output stdout
SQLite
How to creat a table in sqlite and select last rowid
create table ifxload(id integer primary key autoincrement, time varchar(10), load varchar(5)); select * from ifxload where id = (select max(id) from ifxload);
sqlite help
sqlite help http://www.sqlite.org/quickstart.html sqlite and perl inetrface http://zetcode.com/db/sqliteperltutorial/ http://perlmaven.com/simple-database-access-using-perl-dbi-and-sql