Exit the SQLite shell on Android

I’m using SQLite 3 on Mac OS X’s ADB shell to view my application database using:

#sqlite3 mydb.db
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> quit
...> .quit
...>

After I wrongly typed the quit command above, instead of the .quit for example, the shell goes into the ...> prompt where none of the known commands seem to work. I can’t even get out by Ctrl + C, Ctrl + /, Esc, etc.

I have to ⌘ + Q i.e. quit the terminal instance to restart. I know this isn’t exactly a programming question, but it really is annoying enough for me to write here.

How can I restore sanity to the terminal after such errors without relaunching the terminal?

Answer

Type ; and press Enter.

This might fix it. This works for other SQL stuff.

Advertisement

Answer