Created
July 9, 2022 12:28
-
-
Save hp0404/1cc109206b58db301ca7633c80c6debe to your computer and use it in GitHub Desktop.
imports csv file into sqlite3 and later exports a subset of the table to a separate csv
This file contains hidden or 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
| # import | |
| sqlite3 -csv phrases.db ".import np-example.csv phrases_table" | |
| # export | |
| sqlite3 -header -csv phrases.db "select * from phrases_table limit 5;" > tracks.csv |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment