Exit a SQLite 3 database

Question

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?

Answer 1

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.