When using the command line interface sqlite3, a couple of times I have forgotten to use the "." before a command. After that I get a "...>" prompt that I can't seem to escape from and accepts no commands? My only choice is to shut down that terminal and start a new one..

There must be an easy way to get back to the command mode? And what is the "...>" mode?

It's a continuation line, which allows your SQL statements to span multiple lines. Just hit

;<enter>

and you'll receive an error that says "invalid sql" or something similar, and you'll be able to enter another command.


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to