csvsql
Generate SQL statements for a CSV file or execute those statements directly on a database. Included in csvkit. More information: https://csvkit.readthedocs.io/en/latest/scripts/csvsql.html.
-
Generate a
CREATE TABLE
SQL statement for a CSV file:
csvsql {{path/to/data.csv}}
-
Import a CSV file into an SQL database:
csvsql --insert --db "{{mysql://user:password@host/database}}" {{data.csv}}
-
Run an SQL query on a CSV file:
csvsql --query "{{select * from 'data'}}" {{data.csv}}
License and Disclaimer
The content on this page is copyright © 2014—present the tldr-pages team and contributors.This page is used with permission under Creative Commons Attribution 4.0 International License.
While we do attempt to make sure content is accurate, there isn't a warranty of any kind.