sqlite3 CLI commands

connect to a database
- via opstarten : sqlite3
- in the shell : .open

.help 
.exit

.databases : list open databases

.tables

.shema tablename

.import FILE TABLE : import a file into a new table

finsit db

hh
Argenta

.open ‘/mnt/data/doc/1-admin/budget/hh.sqlite’
.import ‘/mnt/data/doc/1-admin/zelfstandige/Bank-copie/Argenta_BE13973433968839_2022-12-31_141703.csv’ Argenta