Last active
April 7, 2019 00:26
-
-
Save psanford/1be9e67d16522ab7913f32033c760d8f to your computer and use it in GitHub Desktop.
sqlite3 examples
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
.mode csv | |
-- import column names from first show | |
.headers on | |
-- show current settings | |
.show | |
.import transactions.csv transactions | |
select * from transactions; | |
-- WAL | |
PRAGMA journal_mode=WAL; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment