💾 Archived View for freeshell.de › tldr › csvsql.gmi captured on 2022-04-28 at 18:18:51. Gemini links have been rewritten to link to archived content

View Raw

More Information

-=-=-=-=-=-=-

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