1. create database
sqlite3 db1
2. create table
create table tb1(id varchar(10), name varchar(10));
3. insert data into table
insert into tb1 values('1','dude1');
4. select data
select * from tb1;
5. view structure
select * from sqlite_master;
6. show help
.help
7. list databases
.databases
8. list tables
.tables
9. change mode
.mode list/column/csv/html/tcl..
10. change seperator
.separator ","
11. change width
.width
12. show headers
.header on/off
13. backup database
echo '.dump' | sqlite3 db1 | gzip -c > db1.dump.gz
14. rebuild database from backup
zcat db1.dump.gz | sqlite3 db2
15. delete table
delete table tb1;
16. exit sqlite
.exit
17. describe table structure
.schema
or
PRAGMA table_info(posts);
