On this page you find all important commands for the CLI tool sqlite3. If the
command you are looking for is missing please ask our AI.
sqlite3
SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world. SQLite is built into all mobile phones and most computers and comes bundled inside countless other applications that people use every day.
List of commands for sqlite3:
-
sql:warp:25557 Export SQLite query to a CSV file$ sqlite3 -header -csv ${db_filepath} ${sql_query} > ${output_filepath}try on your machineexplain this command
-
sqlite3:tldr:2bcaa sqlite3: Open an interactive shell against an existing database.$ sqlite3 ${path-to-database-sqlite3}try on your machineexplain this command
-
sqlite3:tldr:58797 sqlite3: Execute an SQL statement against a database and then exit.$ sqlite3 ${path-to-database-sqlite3} '${SELECT * FROM some_table;}'try on your machineexplain this command
-
sqlite3:tldr:dc2de sqlite3: Start an interactive shell with a new database.$ sqlite3try on your machineexplain this command
-
sqlite:db::create Create an empty sqlite db$ sqlite3 {db_filepath} "VACUUM;"try on your machineexplain this command
-
sqlite:dump:schema Dump sqlite schema into a .sql file$ sqlite3 ${db_filepath} .schema > ${output_sql_filename}try on your machine