how to pass multiple commands to sqlite3 in a one liner shell command
derobert's answer doesn't seem to work with dot-commands, but you can use -cmd
: sqlite3 tolls.sql3 -cmd ".mode csv" ".import tolls.csv tolls"
it accepts multiple -cmd
commands and executes them in order, before the final arg.
Not sure why you want to use SQLite if you don't want the journal (have you considered the much faster WAL mode if speed is a concern?) but you can give multiple commands separated by semicolons:
sqlite3 clipboard_archive.db "PRAGMA journal_mode = OFF; insert into cb (cb_context) values ('clipboard');"