SQLite User Forum

<code>INSERT INTO table2 SELECT * FROM table1 WHERE TRUE</code>

Does all the inserting in one big transaction.

<https://sqlite.org/lang_insert.html>