Re: [sqlite] Shell Feature Request: spaces before dot commands

On Wed Mar 04, 2020 at 12:44:09PM +, 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 ...

Re: [sqlite] Shell Feature Request: spaces before dot commands

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

[sqlite] Shell Feature Request: spaces before dot commands

[SQLite version 3.22.0 2017-11-27 17:56:14] The SQLite shell only recognizes .dot commands without leading spaces. For clarity 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;