multi line commands?

[godfrey-cw]

In the regular sqlite3 shell, since commands need to end with a semi-colon one can use multiline commands (by not ending a line with a semicolon).

Unless I'm mistaken that's not the case with the litecli, e.g. this command works:

ex1> select * from tbl1 where two = 10                                                                                      
+--------+-----+
| one    | two |
+--------+-----+
| hello! | 10  |
+--------+-----+
1 row in set
Time: 0.020s

even though I forgot the ";", but this command fails

ex2> create table tbl3 (g1 varchar(30) primary key,                                                                         
incomplete input

since I pressed enter before finishing the table.

Is there an alternative way to do multiline commands?

[amjith]

Yes. If you press F3 you'll be switched to multi line mode. Then you'll need a semi colon to end a statement.

You can make this your default by editing the config file located at ~/.config/litecli/config.

On Tue, Jun 25, 2019, 07:13 Charlie Godfrey notifications@github.com wrote:

In the regular sqlite3 shell, since commands need to end with a semi-colon one can use multiline commands (by not ending a line with a semicolon).

Unless I'm mistaken that's not the case with the litecli, e.g. this command works:

ex1> select * from tbl1 where two = 10 +--------+-----+ | one | two | +--------+-----+ | hello! | 10 | +--------+-----+ 1 row in set Time: 0.020s

even though I forgot the ";", but this command fails

ex2> create table tbl3 (g1 varchar(30) primary key, incomplete input

since I pressed enter before finishing the table.

Is there an alternative way to do multiline commands?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/dbcli/litecli/issues/60?email_source=notifications&email_token=AAAMA3CRRKF75TGE6SWHI33P4GSODA5CNFSM4H3EO6DKYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4G3OJGYA, or mute the thread https://github.com/notifications/unsubscribe-auth/AAAMA3GZJ3FWDVFOWDRW44LP4GSODANCNFSM4H3EO6DA .

[godfrey-cw]

Wonderful, many thanks for your quick reply! And I literally just found that at the top of the sample config, sorry for not spending a couple minutes with the documentation before posting an issue. Thanks for the great cli!