SQLite Forum

SQLite - CMD prompt - How to exit Statement/Expression after messing up?
Login
I am practicing sqlite in cmd. If I start an expression and mess it up how do I exit the statement to enter a new one?

for example ( here is how it looks in the cmd ):

sqlite> SELECT * FROM COMPANY WHERE (

-->

^ this where I want to exit out of the "-->" and redo the expression.

I tried to press ";" and it will just give me a new line with " --> " I try to press enter and it gives me a new line. I try to type in incorrect code and it will still give me a new line with

"-->"

Does anyone have a trick up their sleeve to get me out of this "-->" so I don't have to close, reopen the cmd and redo all my tables??

PLEASE AND TY!!!