Graphic SQLite tutorial, graphic sqlite

Graphic SQLite tutorial, graphic sqlite

The following operations are successful on your own. No nonsense.

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

Decompress sqlite3.exe and copy it to the desired directory.

Note that the following command line is white, not notepad.

 

1. Start, create a database, and view the database;

After the sqlite3 d: \ test. db file is successfully input during the operation, check the disk d. The file test. db file is not displayed. The file appears only after the. database Command is completed.

 

2. Create a table, view the table, view the table structure, and insert data;

 

3. Sqlite paging writing;

 

4. the query result is output to the file;

 

 

 

5. wildcard query problem diagram;

 

The figure 2 above shows that the query result is faulty. It is believed that this is a problem caused by wildcard matching of Chinese characters; a Chinese character is two bytes;

Create a new table as shown in the following figure and query the wildcards. The result is correct;

Note that the wildcard _ is not -;

 

 

Figure 2 below,

Select A person whose city starts with A, L, or N;
Select the person whose city starts with L or B;
If no result is obtained, it is estimated that the wildcard operation of Sqlite does not support [];