SQLite 基础18

退出SQLite

.quit 和 .exit 都可以用来退出sqlite

代码语言：javascript复制

[root@h102 bin]# ./sqlite3 
SQLite version 3.11.1 2016-03-03 16:17:53
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .quit
[root@h102 bin]# ./sqlite3 
SQLite version 3.11.1 2016-03-03 16:17:53
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .exit
[root@h102 bin]# 

---

命令汇总

• wget http://www.sqlite.org/2016/sqlite-autoconf-3110100.tar.gz
• sha1sum sqlite-autoconf-3110100.tar.gz
• tar -zxvf sqlite-autoconf-3110100.tar.gz
• cd sqlite-autoconf-3110100
• ./configure --prefix=/usr/local/sqlite3.11
• make
• make install
• tree /usr/local/sqlite3.11/
• /usr/local/sqlite3.11/bin/sqlite3 -version
• /usr/local/sqlite3.11/bin/sqlite3 --help
• ./sqlite3
• ./sqlite3 test.db
• ./sqlite3 test.db .dump > test.sql
• cat test.sql
• ./sqlite3 test_tmp.db < test.sql

---

原文地址http://soft.dog/2016/03/15/sqlite-basic/

http sqlite android 数据库 sql

0 人点赞