SQLite ALL
Last login: Fri Dec 5 09:52:08 on ttys002
BeSilent:~ qianfeng$ sqlite3 data.db
SQLite version 3.7.13 2012-07-17 17:46:21
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table USER(id,name,score);//創建表
sqlite> .table
USER
sqlite> create table if not exists USER(id,name,score);//創建表
sqlite> .table
sqlite> create table if not exists USER(id,name,score);
sqlite> .table
sqlite> insert into USER values(2,"奧巴馬",50);
sqlite> select *from USER
...> ;
1|普京|90
2|奧巴馬|50
sqlite> insert into USER values(3,"神雕",100);
sqlite> insert into USER values(4,"楊過",150);
1|普京|90
2|奧巴馬|50
3|神雕|100
4|楊過|150
5|王麗坤|90
sqlite> insert into USER values(6,"陳喬恩",90);
sqlite> select * from USER;
1|普京|90
2|奧巴馬|50
3|神雕|100
4|楊過|150
5|王麗坤|90
sqlite> select * from USER;
1|普京|90
3|神雕|100
4|楊過|150
5|王麗坤|90
6|陳喬恩|90
sqlite> update USER set id=2 where id=6;//修改
sqlite> select *from USER;
1|普京|90
3|神雕|100
4|楊過|150
5|王麗坤|90
2|陳喬恩|90
sqlite> update USER set score= 89 where id=2;//修改
sqlite> select *from USER;
1|普京|90
3|神雕|100
4|楊過|150
5|王麗坤|90
普京|90
神雕|100
楊過|150
王麗坤|90
1|普京|90
3|神雕|100
4|楊過|150
5|王麗坤|90
1|普京|90
2|陳喬恩|89
3|神雕|100
4|楊過|150
5|王麗坤|90
sqlite> select *from USER;
1|普京|90
3|神雕|100
4|楊過|150
5|王麗坤|90
2|陳喬恩|89
sqlite> select * from USER order by score desc;//降序查詢
4|楊過|150
3|神雕|100
1|普京|90
5|王麗坤|90
2|陳喬恩|89
sqlite> select * from USER order by name limit 3;
1|普京|90
4|楊過|150
5|王麗坤|90
5
519
103.8
sqlite> insert into WUGONG(name,uid) values("葵花",5);
sqlite> insert into WUGONG(name,uid) values("獨孤九劍",4);
sqlite> insert into WUGONG(name,uid) values("降龍十八掌",3);
sqlite> insert into WUGONG(name,uid) values("黯然銷魂掌",2);
sqlite> insert into WUGONG(name,uid) values("一陽指",1);
sqlite> select *from USER;
1|普京|90
3|神雕|100
4|楊過|150
5|王麗坤|90
2|陳喬恩|89
sqlite> select USER.id,USER.name,WUGONG.name,USER.score from USER,WUGONG where USER.id=WUGONG.uid;//多表查詢
1|普京|一陽指|90
3|神雕|降龍十八掌|100
4|楊過|獨孤九劍|150
5|王麗坤|葵花|90
2|陳喬恩|黯然銷魂掌|89
1|普京|一陽指|90
5|王麗坤|葵花|90
3|神雕|降龍十八掌|100
4|楊過|獨孤九劍|150
新聞熱點
疑難解答
