kilko.de/tags/sqlite

• til 2026-07-01 #sqlite #csv Importing CSV data into SQLite

  Creating a table from CSV data is very straightforward.

  sqlite3 file.sqlite
  sqlite> .mode csv
  sqlite> .import data.csv tablename
  sqlite> .exit

  That's it.