Skip to content

Instantly share code, notes, and snippets.

@tsuyukimakoto

tsuyukimakoto/sqlite_tips.md

Created July 11, 2019 08:30
Show Gist options
  • Save tsuyukimakoto/b12baed7625212aa4b4672cc513ce613 to your computer and use it in GitHub Desktop.
Save tsuyukimakoto/b12baed7625212aa4b4672cc513ce613 to your computer and use it in GitHub Desktop.
Download ZIP
sqliteのメモ
Raw
sqlite_tips.md

SELECT文の結果にカラム名を表示するようにする

.headers ON

SELECT文の結果を詰めない

.mode column

他にも tabs や html や csv などいくつかある。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment