Graphic SQLite Tutorials

The following are successful for your own operation. No nonsense.

SQLite3 Download: http://pan.baidu.com/s/1o6jzyX0

After decompression appear sqlite3.exe, copy to your desired directory.

Note the following command line is white, not notepad.

1. Start, create database, view database;

When I finished the operation of the Sqlite3 d:\test.db success, view D, and no test.db file, after the. Database command, the file will appear on the D disk.

2. Create table, view table, view table structure, insert data;

3. The wording of SQLite paging;

4. Output the query results to a file;

5. The problem diagram of the wildcard query;

The above two diagram shows that there are problems with the query results; It is believed that this is a problem caused by the characters in the wildcard match; a Chinese is 2 bytes;

The following two chart and then create a new table, the wildcard query, the result is no problem;

Note that the wildcard character _ is not-;

The next two graphs,

Select the person whose city begins with a or L or N;
Select the person whose city begins with L or B;
Without the result, it is estimated that SQLite's wildcard operation does not support [];

Graphic SQLite Tutorials