The first python script I ever wrote does csv to SQL: https://github.com/elidickinson/csv-tools/blob/master/csv2sql.py https://github.com/elidickinson/csv-tools

The first python script I ever wrote does csv to SQL: https://github.com/elidickinson/csv-tools/blob/master/csv2sql.py https://github.com/elidickinson/csv-tools/blob/master/csv2sq... It's very rough, but I actually still use it on occasion. The Python csv library is quite good. There's a lot that can go wrong that LOAD DATA can't handle.