SQLite Basic Commands

sqlite3 database.db # open/create database
.open database.db # open database
.databases # list databases
.quit # exit SQLite

.tables # list tables
.schema users # show table schema
.schema # show all schemas

.mode column # column display mode
.mode list # list mode
.mode line # line mode
.mode csv # CSV mode
.headers on # show column headers

.output file.txt # redirect output to file
.output stdout # redirect to screen
.import file.csv users # import CSV

.help # show all commands
.show # show settings