sqlite

.database

Show location of the database file.


sqlite> .database
main: /root/config.db
sqlite>


.tables

List tables in a database


sqlite> .tables
tree
sqlite>


select

To see data from table, use select statement like you do in MySQL.


select * from TABLE_NAME;


.schema

To see how a table is created, use

.schema TABLE_NAME

This is equivalent to “show create table TABLE_NAME;” command in MySQL.