On 4 Mar 2020, at 12:19pm, no...@null.net wrote: > I like to sometimes indent a block of SQL and change > settings or run dot commands within a transaction, e.g.: > > BEGIN > .mode csv > .import ... > COMMIT;
Dot commands are not SQL commands, they are instructions to the shell application. Transactions, CASE structures, WITH structures, and other such things do not affect them. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users