Use the SQLite under VC

Introduction of SQLite

SQLite is a C-language open source database, mainly for embedded, you can also integrate it in your own desktop program, but also someone to replace access, as a background database.

SQLite supports most SQL92 standards, such as indexing, throttling, triggering, and viewing support.

Supports transactions with NULL, INTEGER, Real, TEXT, and BLOB data types.

Second, download SQLite

SQLite can be downloaded to the official site

Includes: Linux,mac OS X, compiled files under Windows, and source code, help documentation.

Three, the simple use of SQLite

3.1 Establishing a database

C:\sqlite-3_6_11>　sqlite3.exe　dbname.db

Sqlite3.exe followed by the database file name

3.2 Creating data tables

sqlite>　create　table　users(userid　varchar(20)　PRIMARY　KEY,
　　...>　age　int,
　　...>　birthday　datetime);

3.3 Adding records

insert　into　users　values('wang',20,'1989-5-4');
insert　into　users　values('li',22,'1987-11-16');

3.4 Query Records

select　*　from　users　order　by　birthday;

3.5 Deleting records

delete　from　users　where　userid='wang';

3.6 Exit SQLite

sqlite>　.exit

The data structure of the SQLite database is stored in the "sqlite_master" table

Specific commands can be entered. Help view or refer to assistance documentation