SQLite Forum

How to append one table of one database to another table of another database ?
There is no other way.  But if you formulate the query without specifying
column names:

>  INSERT INTO fileDB.table SELECT * FROM memDB.table;

Then the xfer-optimization will kick in and help it to run faster.