From inside SQLite Browser
INSERT INTO temp
SELECT * from two.temp;Sample Code
ATTACH DATABASE 'other.db' AS other;
INSERT INTO other.tbl
SELECT * FROM main.tbl;Perl and SQLite Example along with MongoDB
Within Ubuntu using:SQLiteman
You'll need the DBI package, if not installed do the following within Ubuntu
sudo perl -MCPAN -e shell
cpan> install DBI
cpan> install DBD::SQLite module
Simple Perl script example, creating and inserting into a table: example1.pl
Installing Driver for MongoDB is just as easy, but be warned, it takes a long time to install.
sudo perl -MCPAN -e shell
cpan> install MongoDB::Connection