sqlite3 app.db "ATTACH DATABASE 'archive.db' AS archive;"

Category: Databases & SQL

sqlite3 app.db "ATTACH DATABASE 'archive.db' AS archive;"

Attach another database to the session

Makes archive.db's tables reachable as archive.tablename, enabling cross-database joins in one query. Related: .databases.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.