- Open a database using sqlite3 with the command:
sqlite3 ./dname.db
Now you are connected to the database - To check what database your are connected to use the
.database
command - To exit use
.exit
- To show the tables use
.tables
- To display the structure of a table, you use the
.schema TABLE
command - now use the usual sql commands to explore the data
- you could use
SELECT * FROM tablename