From: http://blog.csdn.net/LocalVar/archive/2008/02/13/3620555.aspx
1. Introduction
An important feature of a database that supports transactions like SQLITE is "Atomic commit ". Atomic commit means that all modification actions in a transaction
First, create the data table:
The syntax rules and usage of this command are essentially the same as most relational databases, so we illustrate the various rules for creating tables in SQLite. However, for some sqlite-specific rules, we will give
Comprehensive Sqlite Learning (2) and sqlite Learning
Finally, CSDN was chosen to sort out the knowledge points published over the past few years. This article was migrated to CSDN in parallel. Because CSDN also supports the MarkDown syntax, it's
1. Create a data table:
The syntax rules and usage of this command are basically the same as those of most relational databases. Therefore, we use examples to demonstrate the rules for creating tables in SQLite. However, we will provide additional
SQLite tutorial (III): Introduction to data tables and views, sqlite View
1. Create a data table:
The syntax rules and usage of this command are basically the same as those of most relational databases. Therefore, we use examples to demonstrate the
How to list all tables in a SQLite databaseThe information in the SQLite database exists in a built-in table sqlite_master that can be used in a querySELECT * from Sqlite_master to see if all table names are listed, just one statement:SELECT name
SqliteoperatorWhat is the SQLite operator?An operator is a reserved word or character that is primarily used in the WHERE clause of an SQLite statement, such as comparison and arithmetic operations.Operator is used to specify conditions in the
Lightweight database SQLite is developed in combination with PHP. Read the lightweight database SQLite is developed in combination with PHP. SQLite is a lightweight database and its design goal is embedded, moreover, it is already used in many
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. It supports mainstream operating systems
SQLite Introduction
SQLite is a very popular embedded database. It supports the SQL language and has good performance only with a small amount of memory. In addition, it is open-source and can be used by anyone. Many open-source projects (Mozilla,
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.