sqlite3 常用命令

http://www.cnblogs.com/myqiao/archive/2011/07/10/2102465.html

MacBook-Pro-od-xin:assets xin$ sqlite3
SQLite version 3.16.2 2017-01-06 16:32:41
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.

sqlite> .open china_cities.db

sqlite> select * from city ;

;号语句才结束