Import a CSV file into an SQL database

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>.
  • Trick copyright: tl;dr; <https://github.com/tldr-pages/tldr>

csvsql --insert --db "{{mysql://user:password@host/database}}" {{data.csv}}

click the source code to copy install csvsql on any operating system with command-not-found.com