On Wed Mar 04, 2020 at 12:44:09PM +0000, Simon Slavin wrote: > 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. Well commands like .import create a table. Since SQLite supports transactional DDL there is certainly a relevance between BEGIN/COMMIT and a call to .import, no? But that is all kind of beside my point: I do not see a technical necessity for dot commands to have no leading space, and my programming experience would be better of without that requirement. -- Mark Lawrence _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
