How do I import a CSV file to DBMS <X>?
Created by Lucas Jones
- Keywords:
- alternative-db import
If you want to import a CSV file into a non-MySQL database, you can generate a SQL script for your CSV file with this command:
csv2sql --null --dump-sql=out.sql csvfile.csv
You can then run that script through your database tool of choice. For example, to import to a SQLite database:
sqlite3 ./mydb.db3 < csvfile.csv