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]
-----------------------------------------------------------------------------