使用终端操作数据库文件，创建 删除 查找内容 插入内容

//创建文件
123456:~ student$ sqlite3 test.db
SQLite version 3.7.12 2012-04-03 19:43:07
Enter ".help" for instructions
Enter SQL statements terminated with a ";"

sqlite> .databases
seq  name             file                                                      
---  ---------------  ----------------------------------------------------------
0    main             /Users/student/test.db            
//创建表shoppinglist                      
sqlite> create table shoppinglist(key integer primary key,item text,price double,groupid integer,dateadded date);
sqlite> go
//显示table中的表
sqlite> .table
shoppinglist
//创建user表
sqlite> create table user(key integer primary key,name text,pwd text);
sqlite> go
sqlite> .table
shoppinglist  user        
//向shoppinglist中添加内容
sqlite> .schema shoppinglist
CREATE TABLE shoppinglist(key integer primary key,item text,price double,groupid integer,dateadded date);
sqlite> insert into "shoppinglist"
   ...> (item,price,groupid,dateadded)
   ...> values ("iphone 3G","199",1,DATETIME('NOW'));
sqlite> go
sqlite> insert into "shoppinglist"
   ...> (item,price,groupid,dateadded)
   ...> values ("iphone 4G","199",1,DATETIME('NOW'));
sqlite> go
//查找内容
sqlite> select * from shoppinglist
   ...> go
1|iphone 3G|199.0|1|2014-03-26 03:07:35
2|iphone 4G|199.0|1|2014-03-26 03:08:28
sqlite>