A more flexible approach might be to add a way to have .import run a
command and use its standard output as the data source, instead of a file.
sqlite> .import "!tail +2 data.csv" mytable
for this example. Lets you do basic ETL stuff for any import format without
having to use temporary files or
Hi all,
I'm sorry if I'm wrong on this list, but I have a small feature request
for the CLI.
I regularly import CSV data with a first line of headers into a SQLite
database by using the .import command. On the first run the destination
table gets automatically created. Later I get more data from
2 matches
Mail list logo