Re: Shell Feature Request: spaces before dot commands

Simon Slavin <[email protected]> Wed, 4 Mar 2020 12:44:09 +0000
Newsgroups gmane.comp.db.sqlite.general
Message-ID <[email protected]>
On 4 Mar 2020, at 12:19pm, [email protected] 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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users