自己总结的sqlite函数和命令.docxVIP

sqlite3常见指令 (1) sqlite v*?db 打开数据库，如不存在则新建一个数据库 instruction 扌旨令 terminated with 终止 farsight^ubuntu:sqlite3 testsqllte?db SQLite version 3?7?9 2011-11-01 00:52:41 Enter help for instructions Enter SQL statements terminated with a u; 11 sqlite _ .quit 退出 sqlite3 sqlite .quit farsight@ubuntu:aaaaaa (3) -database显示当前打开的数据文件 sqlite ?database seq name file 0 main sqlite /home/farsight/testsqlite? db (4) .tables显示数据库中所有表名 (5 ) eSchema table_name 查看表结构 dump table_name 设置导出目标 sqlite .dump users PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE INSERT INSERT INSERT INSERT INSERT INSERT COMMIT;TABLE users (Id integer PRIMARY KEY, Name text, Password Integer); INTOINTO CREATE INSERT INSERT INSERT INSERT INSERT INSERT COMMIT; TABLE users (Id integer PRIMARY KEY, Name text, Password Integer); INTO INTO INTO INTO INTO INTO usersrr VALUES (1, 9xiashuangf, 11); users users users users users VALUES (2f VALUES (3f VALUES (4, VALUES (5f VALUES (6, fpenggang9 f22); 9liyuellnff33); 9weijunjun r, 44); 9yangmei9 f55); 9 fangliqing9 f 66); sqlite .mode column sqlite select * from users; 1 xiashuang 2 penggang 3 liyuelin 4 weijunjun 5 yangmei 6 fangliqing sqlite — (7) mode csv设置显示模式 sqlite ?mode csv sqlite select * from users; lf xiashuangf11 2fpenggangf 22 3f liyuelinf 33 4, weijunjunf44 5f yangmeif55 6r fangliqingf 66 (7) .separatoru 自定义分隔符(引号自己定义) sqlite ? separator ” / r, sqlite select * from users ??? select * from users; Error: near ,rselectr,: syntax error sqllte select * from users; I xiashuang / 11 I penggang / 22 I liyuelin / 33 / weijunjun / 44 I yangmei / 55 / fangliqing / 66 (8) .headers on显示标题栏，同样不显示标题栏为.headers off， sqlite ?headers on sqlite select * from users; Id I Name / Password I xiashuang / 11 I penggang / 22 I liyuelin / 33 / weijunjun / 44 I yangmei / 55 I fangliqing / 66 salite sqlite3常见SQL命令，以“;”结束，以“连个减号表示注释 (1) sqlitecreate table table_name (fl type 1/2 type2,??J;创建新 表 CREATE TABLE users (Id integer PRIMARY KEYf Name text, Password integer); 也可以这样 sqlite create