Skip to content

Instantly share code, notes, and snippets.

@justinc1

justinc1/sqlite-cheatsheet.md

Last active July 10, 2019 07: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 justinc1/19a66f06819d7ecbd001ce97551a53cc to your computer and use it in GitHub Desktop.
Save justinc1/19a66f06819d7ecbd001ce97551a53cc to your computer and use it in GitHub Desktop.
Download ZIP
sqlite cheatsheet
Raw
sqlite-cheatsheet.md 
sqlite3 -readonly db.sqlite3 

.help
.quit
.databases
.dbinfo main
.tables

PRAGMA table_info([auth_user]);

SELECT column1, column2, columnN FROM table_name;
UPDATE table_name
SET column1 = value1, column2 = value2...., columnN = valueN WHERE [condition];
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment