sqlite3 Shell

say it: “see-kwul-lyte-THREE SHEL” /ˌsikwəlˌlaɪtˈθri ˈʃɛl/

The command-line tool for SQLite.

What does sqlite3 Shell do?

The sqlite3 command opens a database file and lets you run SQL.

sqlite3 recipes.db
sqlite> SELECT COUNT(*) FROM recipes;

Level: Novice · More SQLite terms at this level

Updated