also if the semicolon does not get you back to the prompt you may have an open quoted string so try a "; to close it and get you back.
Quoting Dan Kennedy <[EMAIL PROTECTED]>: > On Thu, 2007-08-02 at 08:21 -0600, Scott Derrick wrote: > > This is probably a stupid question but has frustrated me a couple of > times. > > > > 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 means "keep typing, the SQL statement isn't finished yet". > > Add a semi-colon and press enter. The shell will figure the > SQL statement is complete and hand it off to the sqlite libary > for execution. The SQLite libary will tell you it's a syntax > error. > > Dan. > > > > > > Scott > > > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------