sqlite实践

以下sqlite是对 该blog 内容的实践过程

内容：
- 创建数据库
- 创建表
- 在表中插入字段
- 增加
- 查找
- 更新
- 删除

(ccdk-1.5.2alpha)[root@Router-B sqlite]# sqlite3 foo.db
SQLite version 3.14.2 2016-09-12 18:50:49
Enter ".help" for usage hints.
sqlite> create table film(title,length,year,starring);
sqlite> create index film_title_index on film(title);
sqlite> insert into film values ('Silence of the Lambs,The',118,1991,'Jodie Foster');
sqlite> insert into film values ('Contact',153,1997,'Jodie Foster');insert into film values ('Crouching Tiger,Hidden Dragon',120,2000,'Yun-Fat Chow');insert into film values ('Hours,114,2002,'Nicole Kidman');
sqlite> select * from film;
Silence of the Lambs,The|118|1991|Jodie Foster
Contact|153|1997|Jodie Foster
Crouching Tiger,Hidden Dragon|120|2000|Yun-Fat Chow
Hours,The|114|2002|Nicole Kidman
sqlite> select * from film limit 10;
Silence of the Lambs,The|114|2002|Nicole Kidman
sqlite> select * from film limit 1;
Silence of the Lambs,The|118|1991|Jodie Foster
sqlite> select * from film order by year limit 10;
Silence of the Lambs,The|114|2002|Nicole Kidman
sqlite> select * from film order by year desc limit 10;
Hours,The|114|2002|Nicole Kidman
Crouching Tiger,Hidden Dragon|120|2000|Yun-Fat Chow
Contact|153|1997|Jodie Foster
Silence of the Lambs,The|118|1991|Jodie Foster
sqlite> select title,year from film order by year desc limit 10;
Hours,The|2002
Crouching Tiger,Hidden Dragon|2000
Contact|1997
Silence of the Lambs,The|1991
sqlite> select * from film where starring='Jodie Foster';
Silence of the Lambs,The|118|1991|Jodie Foster
Contact|153|1997|Jodie Foster
sqlite> select * from film where starring like 'Jodie%';
Silence of the Lambs,The|118|1991|Jodie Foster
Contact|153|1997|Jodie Foster
sqlite> elect title,year from film where starring like 'Jodie%' and year >= 1985 order by year desc limit 10;
Error: near "elect": syntax error
sqlite> select title,year from film where starring like 'Jodie%' and year >= 1985 order by year desc limit 10;
Contact|1997
Silence of the Lambs,The|1991
sqlite> select count(*) from film;
4
sqlite> select * from film;
Silence of the Lambs,The|114|2002|Nicole Kidman
sqlite> select * from film;
Silence of the Lambs,The|114|2002|Nicole Kidman
sqlite> 
sqlite> update film set starring='Jodie Foster' where starring='Jodee Foster';
sqlite> select * from film;
Silence of the Lambs,The|114|2002|Nicole Kidman
sqlite> delete from film where year < 2000;
sqlite> select * from film;
Crouching Tiger,The|114|2002|Nicole Kidman
sqlite>

源地址在 here

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!