csv2sql is a script for importing CSV data into SQLite. It was created to allow CSV data to be manipulated via SQL queries.
For example, you can:
- Import a CSV file into an SQLite table:
csv2sql -f products.csv
- Export the table that you just created to a CSV file sorted alphabetically by the value of the "ProductName" column:
sqlite3 -header -csv csv2sql.db "SELECT * FROM products ORDER BY ProductName" > sorted-products.csv