Skip to content

sqlite

show headers

.headers ON

display columns

.mode columns

import csv

sqlite3 db.sqlite
.mode csv
.import filename.csv table

export sqlite as json

sqlite3 sqlite.db '.mode json' '.once data.json' "select * from images where user_id=1"