SQLite Forum

SQLite - CMD prompt - How to exit Statement/Expression after messing up?
Login
It's waiting for the semicolon to indicate the end of a statement.  If you get into that situation keep hitting the keys "semicolon, enter" until it recognises the end of the statement.

<code>SQLite version 3.32.3 2020-06-18 14:16:19
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> SELECT * FROM COMPANY WHERE (
   ...> ;
Error: near ";": syntax error
sqlite> </code>