Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@getsadzeg

getsadzeg/sqlite.md

Last active May 15, 2019 09:52
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 getsadzeg/0eefb730e1ea94bfcc60985c4a3c3fdb to your computer and use it in GitHub Desktop.
Save getsadzeg/0eefb730e1ea94bfcc60985c4a3c3fdb to your computer and use it in GitHub Desktop.
Download ZIP
SQL, SQLite: notes and commands
Raw
sqlite.md

So, I dived into SQLite.

Showing tables: .tables

Showing a command which was used to create a table: .schema <table_name>

Showing an actual structure/info about table: PRAGMA TABLE_INFO(<table_name>); - note that this is a SQL command.

The most human-readable mode of output, I think, is done by this:

> .header on

> .mode column

Clearing screen on Linux: .shell clear

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