Use of SQLite command line tool

Recently usedSQLiteMore, the more this thing is used now, the more fascinated, whether it is work or personal entertainment to write things, as long as there is data storage first thoughtSQLiteI have always been disgusted with data storage in the C/S mode.SQLiteFor a long time, I used XML to store my data. I like to store the data in a single file. I can always bring the data to my body, and their compatibility is good enough, it can be used with data files, even in an embedded system...

SQLite features

ACID transaction Zero Configuration-no need to install and manage configuration a complete database file stored in a single disk file can be freely shared between machines in different byte order support database size to 2 TB small enough, roughly 30 thousand rows CCode, K is faster and simpler than some popular databases in most common databases, and easy APIs include TCL binding. At the same time, wrapper supports binding of good comments to other languages.Source codeAnd has more than 90% test coverage independent: no additional dependency on source full open, you can use for any purpose, including selling it to support multiple development languages, C, PHP, Perl, Java, ASP. net, Python

SQLite Installation
Now there are ready-made software packages available for installation in all major Linux versions, and most of the systems are self-contained. Check whether the system is running or not.
$ Sqlite3
Non-Linux systems:Http://www.sqlite.org/download.htmlDownload and install
Next we will use the SQLite command line tool.

open or create a database
$ sqlite3 test. db3
to open or create a new database file
$ sqlite3 test. db3
SQLite version 3.6.23
enter ". help "for instructions
enter SQL statements terminated with a