SQLite

Access to database

# Access to Audit.db file
sqlite3 <database filename>.db 
sqlite3 Audit.db

View databases

# Get command
sqlite3> .help

# Check database name
sqlite> .database

# Show tables
sqlite3> .tables

# show the content in the table
sqlite3> select * from <table name>;

View database with GUI

# Open a sqlitebrwoser
sqlitebrowser database.db

You can run SQL queries from the application.

Last updated