Skip to content

Instantly share code, notes, and snippets.

@alexpchin

alexpchin/useful-sqlite3-commands.md

Created July 22, 2015 12:34
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 alexpchin/1409fdba5368ded13b85 to your computer and use it in GitHub Desktop.
Save alexpchin/1409fdba5368ded13b85 to your computer and use it in GitHub Desktop.
Download ZIP
Useful sqlite3 commands
Raw
useful-sqlite3-commands.md

List the tables in your database:

.tables

List how the table looks:

.schema tablename

Print the entire table:

SELECT * FROM tablename;

List all of the available SQLite prompt commands:

.help

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