.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.