Skip to content

Latest commit

 

History

History
23 lines (12 loc) · 548 Bytes

README.md

File metadata and controls

23 lines (12 loc) · 548 Bytes

sql2csv

C shell script to convert an SQL file to CSVs (one for each table). Especially useful when running into errors like "Parse error: file is not a database" and not wanting to take out an online subscription (e.g. https://www.rebasedata.com/convert-sql-to-csv-online).

Should be easily convertable to other shells.

E.g. ./sql2csv.csh WILL GIVE

employees.sql written to

  11 departments.csv

331604 dept_emp.csv

  49 dept_manager.csv

300025 employees.csv

967331 salaries.csv

443309 titles.csv