Exit a SQLite 3 database

Sqlite

Sqlite Problem Overview

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?

Sqlite Solutions

Solution 1 - Sqlite

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.

Solution 2 - Sqlite

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.

Solution 3 - Sqlite

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

see the Example

Solution 4 - Sqlite

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.

Solution 5 - Sqlite

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.

Solution 6 - Sqlite

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.

Categories
Recommended Sqlite Solutions

Previous Solution:

cannot export const arrow function

Ecmascript 6

Next Solution:

Serving static assets in webpack dev server

WebpackWebpack Dev-Server

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionHarry BoyView Question on Stackoverflow
Solution 1 - SqliteJimmyBView Answer on Stackoverflow
Solution 2 - SqlitenjachowskiView Answer on Stackoverflow
Solution 3 - SqliteVishal Kumar SahuView Answer on Stackoverflow
Solution 4 - SqliteKurt Van den BrandenView Answer on Stackoverflow
Solution 5 - Sqliteuser8616916View Answer on Stackoverflow
Solution 6 - SqliteBanafshe BamdadView Answer on Stackoverflow