CmdID

CmdID / Commands

csvsql

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

On several platforms

Opens CmdID with your command. It is read in your browser and sent nowhere.

Several platforms

from tldr-pages, CC BY 4.0

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

Generate a CREATE TABLE SQL statement for a CSV file

csvsql path/to/data.csvIdentify

Import a CSV file into an SQL database

csvsql --insert --db "mysql://user:password@host/database" data.csvIdentify

Run an SQL query on a CSV file

csvsql --query "select * from 'data'" data.csvIdentify