Skip to content

Instantly share code, notes, and snippets.

@whamtet

whamtet/sqlite.sql

Created October 17, 2022 23:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save whamtet/2209798f6fb2677d0a0d765c24a6b0c8 to your computer and use it in GitHub Desktop.
Save whamtet/2209798f6fb2677d0a0d765c24a6b0c8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sqlite.sql
-- run as cat sqlite.sql | sqlite3
CREATE TABLE ichiba (
disp_date INTEGER,
genre3_id INTEGER,
gms REAL,
order_cnt INTEGER
);
.mode tabs
.import acr_ichiba_gms_g3_m_202210.tsv ichiba
SELECT MAX(disp_date) FROM ichiba;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment