What is SQLite_MySQL?

I. What is SQLiteSQLite? it is a lightweight database designed to be embedded. it is already used in many embedded products and occupies very low resources, in an embedded device, only a few hundred KB of memory is required. SQLite supports mainstream operating systems such as Windows linuxunix, and can be combined with many programming languages, such as Tcl, PHP, Java, and ODBC interfaces. Similarly, compared with Mysql, Post 1, what is SQLite?

SQLite is a lightweight database. it is designed to be embedded and has been used in many embedded products. it occupies very low resources. in embedded devices, it may only take several hundred KB of memory.

SQLite supports mainstream operating systems such as Windows, Linux, and Unix, and can be combined with many programming languages, such as Tcl, PHP, Java, and ODBC interfaces, similar to Mysql and PostgreSQL, the two world-renowned open-source database management systems, the processing speed is faster than that of them.

Although SQLite is very small, the supported SQL statements are not inferior to other open-source databases, and it also supports transaction processing. Some people also say that it is like Microsoft's Access. sometimes it is a bit similar, but in fact they are quite different. For example, SQLite supports cross-platform, simple operations, and can directly create databases in many languages. Unlike Access, SQLite requires Office support. If you are a very small application or want to do embedded development without a suitable database system, you can now consider using SQLite.

II. download and install and use SQLite

SQLite official address: http://www.sqlite.org

SQLite page: http://www.sqlite.org/download.html/

We take Windows version sqlite-shell-win32-x86-3071000.zip (released on) as an example to introduce its installation and use.

After downloading, decompress sqlite-shell-win32-x86-3071000.zip to the D: \ SQLite directory to complete the installation. The directory contains only one file, sqlite3.exe.

Open a CMD command window. Enter the SQLite Directory, enter sqlite3 test. db, start the SQLite program, and create a database named test.

Create a table named category. The table has three fields: categoryId, title, and addtime. The SQL statement is as follows:

　　create table Category (CategoryId integer primary key autoincrement not null, Title text(50), 　　AddTime text(50));

Insert two records into the Category table. The statement is as follows:

　　

insert into Category (Title,AddTime) values ('html-css', '2012-2-17');　　insert into Category (Title,AddTime) values ('javascript', '2012-2-17');

Then read the inserted record. The statement is as follows:

　　

select * from Category;

Finally, enter the. quit command to exit. View the D: \ sqlite directory and you will find an additional test. db database file. Entire process

What is the content of SQLite_MySQL above? for more information, see The PHP Chinese website (www.php1.cn )!