csvsql

Generate SQL statements for a CSV file or execute those statements directly on a database.

Included in csvkit.

More information.

• 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}

Copyright © 2014—present the tldr-pages team and contributors.

This work is licensed under the Creative Commons Attribution 4.0 International License (CC-BY).

CC-BY