SQLite数据库安装及基本操作指南

/* For Debian or Ubuntu /* 
$ sudo apt-get install sqlite3 sqlite3-dev 
 
/* For RedHat, CentOS, or Fedora/* 
$ yum install SQLite3 sqlite3-dev 
SQLite on Mac OS X

sqlite> create table mytable(id integer primary key, value text); 
2 columns were created. 

sqlite> insert into mytable(id, value) values(1, 'Micheal'); 
sqlite> insert into mytable(id, value) values(2, 'Jenny'); 
sqlite> insert into mytable(value) values('Francis'); 
sqlite> insert into mytable(value) values('Kerk'); 

sqlite> select * from test; 
1|Micheal 
2|Jenny 
3|Francis 
4|Kerk 

sqlite> .mode column; 
sqlite> .header on; 
sqlite> select * from test; 
id     value 
----------- ------------- 
1      Micheal 
2      Jenny 
3      Francis 
4      Kerk 

sqlite> alter table mytable add column email text not null '' collate nocase;; 

sqlite> create view nameview as select * from mytable; 

sqlite> create index test_idx on mytable(value); 

sqlite> .schema [table] 

sqlite > .tables 

sqlite > .indices [table ] 

sqlite > .output [filename ] 
sqlite > .dump 
sqlite > .output stdout 

sqlite > .read [filename ] 

sqlite >.output [filename.csv ] 
sqlite >.separator , 
sqlite > select * from test; 
sqlite >.output stdout 

sqlite >create table newtable ( id integer primary key, value text ); 
sqlite >.import [filename.csv ] newtable 

/* usage: sqlite3 [database] .dump > [filename] */ 
sqlite3 mytable.db .dump > backup.sql 

/* usage: sqlite3 [database ] < [filename ] */ 
sqlite3 mytable.db < backup.sql