Forrest logo
back to context overview

csvsql

List of commands for csvsql:

  • csvsql:tldr:574b2 csvsql: Generate a `CREATE TABLE` SQL statement for a CSV file.
    $ csvsql ${path-to-data-csv}
    try on your machine
    explain this command
  • csvsql:tldr:5cfe8 csvsql: Run an SQL query on a CSV file.
    $ csvsql --query "${select * from 'data'}" ${data-csv}
    try on your machine
    explain this command
  • csvsql:tldr:de039 csvsql: Import a CSV file into an SQL database.
    $ csvsql --insert --db "${mysql:--user:password@host-database}" ${data-csv}
    try on your machine
    explain this command
back to context overview