Skip to content

Instantly share code, notes, and snippets.

@davidjguru

davidjguru/Working with SQLite3

Last active November 1, 2017 17:48
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 davidjguru/6d64899e8943c559f727d28e8560cbd2 to your computer and use it in GitHub Desktop.
Save davidjguru/6d64899e8943c559f727d28e8560cbd2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Working with SQLite3
# Access to SQLite prompt
sqlite3;
# You're in sqlite>
# Open the database
.open /path/to/database/database.db
# Show databases in the current database connection
.database
# Show all the tables within the database
.tables
# Print an entire table
SELECT * FROM tablename;
# Print how is build a table
.schema tablename
# Closing session
.exit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment