[SOLVED] Run command-line SQLite 3 query and exit

Issue

We can use the -cmd option with sqlite3 to run a query, but then sqlite3 opens the database and waits in there for interactive input. How can we run a query on sqlite3 from the command line and exit?

Solution

Just include the command in quotes after the database file argument.

For example, the following creates a table called abc:

sqlite3 test.db 'create table abc (col0 int)'

Answered By - gbrener

Answer Checked By - David Goodson (WPSolving Volunteer)