While there are lines to be edited:
  Press up arrow until line is recalled
  Edit the line
  Press the ENTER key to enter that line

Maybe you have to compile your own to include readline (on Linux), but it works 
for me.  Both Linux and Windows.

-- 
The fact that there's a Highway to Hell but only a Stairway to Heaven says a 
lot about anticipated traffic volume.

>-----Original Message-----
>From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> On
>Behalf Of Csanyi Pal
>Sent: Saturday, 18 January, 2020 14:31
>To: sqlite-users@mailinglists.sqlite.org
>Subject: [sqlite] To edit in sqlite3 CLI multiline SQL statements?
>
>Hello,
>
>can one edit a multiline SQL statement in the sqlite3 CLI?
>
>Say I entered the following multiline SQL statement:
>
>sqlite> SELECT 1 UNION ALL
>    ...> SELECT 2 UNION ALL
>    ...> SELECT 3
>    ...> ;
>
>Then after a while I want to run it again, then how can I use the bash
>history to get back my multiline SQL statement, to eventually modify it
>and re-run it again?
>
>Is there a way to do this in sqlite3 CLI?
>
>--
>Best, Paul Chany
>_______________________________________________
>sqlite-users mailing list
>sqlite-users@mailinglists.sqlite.org
>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to