4 ms·
https://www.sqlite.org/csv.html https://www.sqlite.org/csv.html >The CSV Virtual Table >The CSV virtual table reads RFC 4180 formatted comma-separated values,
by nabla9 8y ago
https://www.sqlite.org/csv.html https://www.sqlite.org/csv.html
>The CSV Virtual Table
>The CSV virtual table reads RFC 4180 formatted comma-separated values, and returns that content as if it were rows and columns of an SQL table.
>The CSV virtual table is useful to applications that need to bulk-load large amounts of comma-separated value content. The CSV virtual table is also useful as a template source file for implementing other virtual tables.
>The CSV virtual table is not built into the SQLite amalgamation. It is available as a separate source file that can be compiled into a loadable extension. Typical usage of the CSV virtual table from the command-line shell would be something like this: