3 ms·
Great tip. A simple utility script can be used for repeated use/customization: https://pastebin.com/qEkimk7W https://pastebin.com/qEkimk7W Another advantage is
by noisy_boy 5y ago
Great tip. A simple utility script can be used for repeated use/customization: https://pastebin.com/qEkimk7W https://pastebin.com/qEkimk7W
Another advantage is that this can be executed to import as part of initialization and get to sqlite prompt with the table ready for sql execution:
$ csv_to_table.sh sample-test.csv
Or it can be executed using heredoc for non-interactive execution as well:
$ csv_to_table.sh sample-test.csv <<-CMD
select * from sample_test limit 10;
CMD
... output ...