one-linerの検索結果1 - 1 件 / 1件

• あとで読む

  One-liner for running queries against CSV files with SQLite

  • 4 users
  • til.simonwillison.net
  • テクノロジー
  • 2022/06/22

  I figured out how to run a SQL query directly against a CSV file using the sqlite3 command-line utility: sqlite3 :memory: -cmd '.mode csv' -cmd '.import taxi.csv taxi' \ 'SELECT passenger_count, COUNT(*), AVG(total_amount) FROM taxi GROUP BY passenger_count' This uses the special :memory: filename to open an in-memory database. Then it uses two -cmd options to turn on CSV mode and import the taxi.

  • SQLite