SQLite management tools

At the beginning, I used SQLite to write down some simple entry content and forget it.

Management tools:
SQLite shell: the command line tool. When you look tired, you can practice the command and use it on the official website.
: Http://www.sqlite.org/download.html, all platforms are available.
SQLite manager for Firefox: Firefox plug-in. For my Firefox Control, no matter how good it is, it is easy to see more data.
: Https://code.google.com/p/sqlite-manager/

SQLite shell basic commands:
Open and create a database:
SQLite new. DB
Create a table:
Create Table T1 (age varchar (40), age smallint );
View the table structure:
You can view the SQLite built-in management table sqlite_master:
Select name from sqlite_master where type = "table ";
You can also use the built-in command:
. Table
Insert data
Insert into T1 values ("HJ", 26 );
Print the result to a file
. Output file.txt
Other SQL commands are no longer written. Note that the shell should be followed by a; separator.
Shell specific application to see the official site description: http://www.sqlite.org/sqlite.html