To edit in sqlite3 CLI multiline SQL statements?
Csanyi Pal <[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <[email protected]> |
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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users