Exit a SQLite 3 database

I have an SQLite 3 database in SUSE Linux.

It's stuck at the command prompt like so:

sqlite> q ...> exit ...> .exit ...> quit ...> .quit

How do I exit out of the database?

1

6 Answers

Type ; + Enter to terminate the current statement (will give an error message because what you typed so far is not a valid statement but never mind). Then .quit + Enter.

Note that in SQLite 3, SQL statements must be terminated with a delimiter, which is ; by default. The non-SQL commands, which start with a ., do not need to be terminated this way, but they are considered complete as soon as Enter is pressed.

If a command does not start with a . and Enter is pressed without the SQL termination character, the CLI client displays the "continuation prompt" (...> in your case) and expects the SQL command to be continued on the following line(s) until it is properly terminated.

See also Command Line Shell For SQLite.

1

Ctrl + D will get you out of the SQLite 3 database command prompt.

That is: hold the "Ctrl" button then press the lowercase d key on your keyboard at the same time and you will escape the SQLite 3 command prompt.

4

You have entered multiline command input. To exit the command multiline input use a semicaolon (;) to complete your command. And then use .exit to exit from sqlite commandline or continue with what you want to do.

sqlite>
sqlite> cd ...> ...> .exit ...> .exit ...> exit() ...> ; # This semicolon completes the incomplete cd command
Error: near "cd": syntax error
sqlite> .exit

5

You can terminate the SQLite 3 program by typing your system's end-of-file character (usually a Ctrl + D). Use the interrupt character (usually a Ctrl + C) to stop a long-running SQL statement.

For the Windows command prompt, pressing Ctrl + Z and then pressing Enter worked for me. It directly brought me out of the sqlite> prompt.

If you want to stay at the sqlite> prompt, but just come out of the inner prompt, ...>, then as JimmyB has said, type ; and press Enter. It just completes your statement, the prompt ...> shows it is expecting more in the statement so far typed, as SQLite statements always end with a semicolon.

2

To see all SQLite commands in the SQLite prompt, use the .help command. Before stucking at the command prompt, you can use the .exit command.

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy