Compilation and exercise of SQLite

[Disclaimer: All Rights Reserved. You are welcome to reprint it. Do not use it for commercial purposes. Contact Email: feixiaoxing @ 163.com]

SQLite has never been heard of before, but it has never been used. Today, we downloaded the source code from the official SQLite website, that is, the source code above ww.sqlite.org. It is very easy to use. The steps are very simple for your reference. This is only used as a learning database, not linked to your own code as a dll library or lib library, so you can simply generate an execution file.

(1) first download the latest SQLite code, http://www.sqlite.org/download.html, the first address at the source code;

(2) After downloading the file locally, decompress it. We found that there are actually four files, namely shell. C, sqlite3.c, sqlite3.h, and sqlite3ext. h;

(3) create a local VC console project and add four files to the project;

(4) directly input F7. the compiler will compile and link to generate a version;

(5) In the DEBUG directory, a sqlite3 execution file is ready.

In order to test whether our SQLite is easy to use, we can immediately start the execution file. If it remains in the compiler, press F5 to print the SQLite>, at this time, we can enter the content, for example, creating a table at will,

 

Create Table tbl1 (one varchar (10), two smallint );

Insert into tbl1 values ('hello', 10 );

Insert into tbl1 values ('China', 20 );

Select * From tbl1;

With the above operations, we can smoothly create a table, insert our own data into the table, and output and print the data. As for the subsequent content, you can continue to learn and improve according to the online tutorials.