howto exit ?

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

howto exit ?

Tero Vihavainen
yes I'm newbie ... :)

****** clip ***

tjv@shampoo:/public$ ./sqlite3-3.2.7.bin
SQLite version 3.2.7
Enter ".help" for instructions
sqlite> ^[[A^[[A^[[B^[[Bqqqccc
    ...> qq
    ...> ^[
    ...>
    ...> ^X^X^X
    ...>
    ...>
    ...>
    ...> .exit
    ...>
    ...>
    ...> .quit
    ...> .bye
    ...> exit
    ...> quit
    ...> bye
    ...> kuole
    ...> g^G^G^G^G
    ...> ^G^G
    ...> .help
    ...> ..help
    ...> help
    ...> aaaapuva
    ...>
    ...>
    ...>
    ...>
    ...> apdoskf
    ...>
    ...> kill
    ...> ?
    ...> hellothere
    ...> qqq
    ...>
    ...> ^[[11~^[[12~^[[14~^[[17~^[[18~^[[18~^[[19~^[^[^[
    ...> ^[^[
    ...> ^[
    ...> INSERT
    ...> ;
    ...> ;;
    ...>
    ...>
    ...> ;
    ...> .exit
    ...> .help;
    ...> ;
    ...>

--
Tero Vihavainen
[hidden email]

Reply | Threaded
Open this post in threaded view
|

RE: howto exit ?

Downey, Shawn
sqlite>  .exit

The "-->"  indicates a line continuation.  Usually you can terminate it
with a semicolon or by closing a quote.  This gets you back to the
"sqlite>" prompt where you can type ".help" and ".exit".

Shawn M. Downey
MPR Associates
10 Maxwell Drive, Suite 204
Clifton Park, NY 12065
518-371-3983 x3 (work)
860-508-5015 (cell)
 

-----Original Message-----
From: Tero Vihavainen [mailto:[hidden email]]
Sent: Thursday, November 03, 2005 9:08 AM
To: [hidden email]
Subject: [sqlite] howto exit ?

yes I'm newbie ... :)

****** clip ***

tjv@shampoo:/public$ ./sqlite3-3.2.7.bin
SQLite version 3.2.7
Enter ".help" for instructions
sqlite> ^[[A^[[A^[[B^[[Bqqqccc
    ...> qq
    ...> ^[
    ...>
    ...> ^X^X^X
    ...>
    ...>
    ...>
    ...> .exit
    ...>
    ...>
    ...> .quit
    ...> .bye
    ...> exit
    ...> quit
    ...> bye
    ...> kuole
    ...> g^G^G^G^G
    ...> ^G^G
    ...> .help
    ...> ..help
    ...> help
    ...> aaaapuva
    ...>
    ...>
    ...>
    ...>
    ...> apdoskf
    ...>
    ...> kill
    ...> ?
    ...> hellothere
    ...> qqq
    ...>
    ...> ^[[11~^[[12~^[[14~^[[17~^[[18~^[[18~^[[19~^[^[^[
    ...> ^[^[
    ...> ^[
    ...> INSERT
    ...> ;
    ...> ;;
    ...>
    ...>
    ...> ;
    ...> .exit
    ...> .help;
    ...> ;
    ...>

--
Tero Vihavainen
[hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: howto exit ?

Clay Dowling
In reply to this post by Tero Vihavainen

> .quit

bash$


That should probably take care of you.

Clay Dowling

Tero Vihavainen said:

> yes I'm newbie ... :)
>
> ****** clip ***
>
> tjv@shampoo:/public$ ./sqlite3-3.2.7.bin
> SQLite version 3.2.7
> Enter ".help" for instructions
> sqlite> ^[[A^[[A^[[B^[[Bqqqccc
>     ...> qq
>     ...> ^[
>     ...>
>     ...> ^X^X^X
>     ...>
>     ...>
>     ...>
>     ...> .exit
>     ...>
>     ...>
>     ...> .quit
>     ...> .bye
>     ...> exit
>     ...> quit
>     ...> bye
>     ...> kuole
>     ...> g^G^G^G^G
>     ...> ^G^G
>     ...> .help
>     ...> ..help
>     ...> help
>     ...> aaaapuva
>     ...>
>     ...>
>     ...>
>     ...>
>     ...> apdoskf
>     ...>
>     ...> kill
>     ...> ?
>     ...> hellothere
>     ...> qqq
>     ...>
>     ...> ^[[11~^[[12~^[[14~^[[17~^[[18~^[[18~^[[19~^[^[^[
>     ...> ^[^[
>     ...> ^[
>     ...> INSERT
>     ...> ;
>     ...> ;;
>     ...>
>     ...>
>     ...> ;
>     ...> .exit
>     ...> .help;
>     ...> ;
>     ...>
>
> --
> Tero Vihavainen
> [hidden email]
>
>


--
Simple Content Management
http://www.ceamus.com

Reply | Threaded
Open this post in threaded view
|

Re: howto exit ?

Jim Dodgen
the ...> indicates uou are continuing a statement, from you r example it looks
like you are lost. at this point you need to do what is needed to complete a
statement, even though the statement is garbage, try typing a ; (to end a sql
statemtent. you could be inside a quote so type a "; or '; to end the statement.

also "control d" should exit just about anything (including sqlite3) on unix
systems


Quoting Clay Dowling <[hidden email]>:

>
> > .quit
>
> bash$
>
>
> That should probably take care of you.
>
> Clay Dowling
>
> Tero Vihavainen said:
> > yes I'm newbie ... :)
> >
> > ****** clip ***
> >
> > tjv@shampoo:/public$ ./sqlite3-3.2.7.bin
> > SQLite version 3.2.7
> > Enter ".help" for instructions
> > sqlite> ^[[A^[[A^[[B^[[Bqqqccc
> >     ...> qq
> >     ...> ^[
> >     ...>
> >     ...> ^X^X^X
> >     ...>
> >     ...>
> >     ...>
> >     ...> .exit
> >     ...>
> >     ...>
> >     ...> .quit
> >     ...> .bye
> >     ...> exit
> >     ...> quit
> >     ...> bye
> >     ...> kuole
> >     ...> g^G^G^G^G
> >     ...> ^G^G
> >     ...> .help
> >     ...> ..help
> >     ...> help
> >     ...> aaaapuva
> >     ...>
> >     ...>
> >     ...>
> >     ...>
> >     ...> apdoskf
> >     ...>
> >     ...> kill
> >     ...> ?
> >     ...> hellothere
> >     ...> qqq
> >     ...>
> >     ...> ^[[11~^[[12~^[[14~^[[17~^[[18~^[[18~^[[19~^[^[^[
> >     ...> ^[^[
> >     ...> ^[
> >     ...> INSERT
> >     ...> ;
> >     ...> ;;
> >     ...>
> >     ...>
> >     ...> ;
> >     ...> .exit
> >     ...> .help;
> >     ...> ;
> >     ...>
> >
> > --
> > Tero Vihavainen
> > [hidden email]
> >
> >
>
>
> --
> Simple Content Management
> http://www.ceamus.com
>
>