On 18 Mar 2019, at 3:21pm, Jonathan Moules <[email protected]> wrote:
> At this point I'm starting to think that the best option is to create a new
> database with the requisite structure and copy the data across via an ATTACH
> (there are only two tables and one will almost always be empty at this point).
That could work well. Create the new database and set
PRAGMA journal_mode = OFF
then close it, attach it to your main database and use the
INSERT INTO table SELECT ...
syntax.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
