sqlite> create view v_books as select * from books;
sqlite> .tables
books v_books
sqlite> .schema v_books
CREATE VIEW v_books as select * from books;
sqlite>
创建索引
sqlite> create index index_books on books(publisher);
sqlite> .indices books
index_books
sqlite> .dump //打印当前数据库所有操作内容
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE books(id integer primary key, title nvarchar(50),pubdate datetime, publisher text not null default '' collate nocase);
INSERT INTO "books" VALUES(1,'交换机.路由器.防火墙','2007-08-28','电子工业出版社');
INSERT INTO "books" VALUES(2,'网络硬件搭建与配置实践','2007-01-20','电子工业出版社');
INSERT INTO "books" VALUES(3,'英语沙龙 ENGLISH SALON 实战版','2005-12-31','世界知识出版社');
INSERT INTO "books" VALUES(4,'英语沙龙 ENGLISH SALON 朗读版','2006-12-20','世界知识出版社');
INSERT INTO "books" VALUES(100,'软件项目管理理论与案例分析','2007-08-30','中国电力出版社');
INSERT INTO "books" VALUES(105,'初级会计电算化','2006-03-27','中国财政经济出版社');
INSERT INTO "books" VALUES(300,'供应链管理 ------战略、规划与运营','2003-02-28','社会科学文献出版社');
INSERT INTO "books" VALUES(301,'UML实战教程 ------面向.NET开发人员','2006-12-31','清华大学出版社');
INSERT INTO "books" VALUES(302,'Project 2003 企业项目管理 快译通','2007-02-28','人民邮电出版社');
CREATE VIEW v_books as select * from books;
CREATE INDEX index_books on books(publisher);
COMMIT;
sqlite>
导出数据库到 SQL 文件
sqlite> .output bookstore.sql //创建一个空文件bookstore.sql
sqlite> .dump //将dump显示的内容写入空文件bookstore.sql
sqlite> .output stdout //恢复屏幕输出，不再将后面其它操作输出内容写入到文件bookstore.sql中
sqlite> .exit
[root@host10 myth]#
[root@host10 myth]# cat bookstore.sql //查看写入的文件内容
PRAGMA foreign_keys=OFF;
CREATE TABLE books(id integer primary key, title nvarchar(50),pubdate datetime, publisher text not null default '' collate nocase);
INSERT INTO "books" VALUES(1,'交换机.路由器.防火墙','2007-08-28','电子工业出版社');
INSERT INTO "books" VALUES(2,'网络硬件搭建与配置实践','2007-01-20','电子工业出版社');
INSERT INTO "books" VALUES(3,'英语沙龙 ENGLISH SALON 实战版','2005-12-31','世界知识出版社');
INSERT INTO "books" VALUES(4,'英语沙龙 ENGLISH SALON 朗读版','2006-12-20','世界知识出版社');
INSERT INTO "books" VALUES(100,'软件项目管理理论与案例分析','2007-08-30','中国电力出版社');
INSERT INTO "books" VALUES(105,'初级会计电算化','2006-03-27','中国财政经济出版社');
INSERT INTO "books" VALUES(300,'供应链管理 ------战略、规划与运营','2003-02-28','社会科学文献出版社');
INSERT INTO "books" VALUES(301,'UML实战教程 ------面向.NET开发人员','2006-12-31','清华大学出版社');
INSERT INTO "books" VALUES(302,'Project 2003 企业项目管理 快译通','2007-02-28','人民邮电出版社');
CREATE VIEW v_books as select * from books;
CREATE INDEX index_books on books(publisher);
COMMIT;
[root@host10 myth]#
删除数据库
[root@host10 myth]# find / -name bookstore.db
/home/myth/bookstore.db
[root@host10 myth]# rm -f /home/myth/bookstore.db
从 SQL 文件导入数据库
[root@host10 myth]# sqlite3 bookstore.db
SQLite version 3.6.20
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .databases
seq name file
--- --------------- ----------------------------------------------------------
0 main /home/myth/bookstore.db
sqlite> .tables
sqlite>
sqlite> .read bookstore.sql
sqlite> .dump //打印当前数据库所有操作内容
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE books(id integer primary key, title nvarchar(50),pubdate datetime, publisher text not null default '' collate nocase);
INSERT INTO "books" VALUES(1,'交换机.路由器.防火墙','200