Skip to content

Instantly share code, notes, and snippets.

@arifsuhan

arifsuhan/db_query.md

Last active July 7, 2023 06:22
Show Gist options
  • Save arifsuhan/e5460b1c8d8e8053c8333893ccacccf3 to your computer and use it in GitHub Desktop.
Save arifsuhan/e5460b1c8d8e8053c8333893ccacccf3 to your computer and use it in GitHub Desktop.
Download ZIP
query raw database sqlite sqlite3
Raw
db_query.md

Enter into DB

sqlite3 [filename.db]

Check Table List

.tables

Schema of Tables

.schema [tablename]

View data

Select * From [tablename]

Referece: https://sqlite.org/cli.html

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