Discovered: Oct 14, 2023 18:07 Steve Wart in Elk: “@roland okay I figured it out ;-)The dot…” ¦ Elk <– TIL: How to convert CSV to SQL using SQLite CLI without using an external tool like csvs-to-sqlite –> QUOTE:The dot-commands for the sqlite3 CLI can be executed on the command line if they are embedded in quoted strings. More info here: sqlite.org/draft/cli.html (section 4.2)... Not obvious. There was a SO question but quoting the dot commands wasn’t the top answer! Most people suggested reading the commands from a file (ew) –> hard to find docs :-) : https://www.sqlite.org/draft/cli.html

Leave a comment on github