SQLite简介

sqlite_query($db, "INSERT INTO user VALUES('user".$i."'" ",'user".$i."@hichina.com')");
sqlite_query($db, "delete from user where user=’user99’");
sqlite_query($db, 'UPDATE user SET email="lilz@hichina.com" where name="user1"');

　　4、SQLite的管理

　　管理工具也有不少，建议您使用sqlitemanager，用法酷像phpmyadmin.

　　可以到 http://sqlitemanager.sourceforge.net/下载

　　About SQLite

　　SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine. Features include:

　　Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures.

　　Zero-configuration - no setup or administration needed.

　　Implements most of SQL92. (Features not supported)

　　A complete database is stored in a single disk file.

　　Database files can be freely shared between machines with different byte orders.

　　Supports databases up to 2 terabytes (241 bytes) in size.

　　Sizes of strings and BLOBs limited only by available memory.

　　Small code footprint: less than 250KiB fully configured or less than 150KiB with optional features omitted.

　　Faster than popular client/server database engines for most common operations.

　　Simple, easy to use API.

　　TCL bindings included. Bindings for many other languages available separately.

　　Well-commented source code with over 95% test coverage.

　　Self-contained: no external dependencies.

　　Sources are in the public domain. Use for any purpose.

　　The SQLite distribution comes with a standalone command-line access program (sqlite) that can be used to administer an SQLite database and which serves as an example of how to use the SQLite library.