 <p>If you had two tables in the same database, you could use a statement like this:</p> <pre class="lang-sql prettyprint-override"><code>INSERT INTO messages1 SELECT * FROM messages2 </code></pre> <p>When you have two different database files, you can <a href="http://www.sqlite.org/lang_attach.html" rel="nofollow">ATTACH</a> one to the other:</p> <pre class="lang-sql prettyprint-override"><code>ATTACH DATABASE '...' AS toMerge </code></pre> <p>and then access it by prefixing the table name with the database name:</p> <pre class="lang-sql prettyprint-override"><code>INSERT INTO messages SELECT * FROM toMerge.messages </code></pre>