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

Reply via email to