/ mozey.co / blog

python csv

December 1, 2015

🔗 Generate sql from csv to import data

pip install csvkit

csvsql --dialect mysql --snifflimit 100000 bigdatafile.csv > maketable.sql

🔗 Odo: Shapeshifting for your data

Loading CSVs into SQL Databases