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
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
Reference: http://www.sqlite.com.cn/MySqlite/5/100.Html
SQLite is different from most other SQL database engines, because its primary design goal is to simplify:
Easy to manage
Easy to use
Easy to embed other large programs
Easy to maintain and
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
Data | database
SQLite is a lightweight database, its design goal is embedded, and has been used in many embedded products, it occupies very low resources, in embedded devices, may only need hundreds of K of memory is enough. It can support
工欲善其事, its prerequisite. Learning SQLite's command-line tools is very helpful for us to learn about SQLite itself. The basic one is that it makes the process of learning sqlite easier and more enjoyable. let's go back to the official website of
To do well, you must first sharpen your tools. Learning SQLite's command line tool is very helpful for us to learn SQLite itself. The most basic one is that it makes learning SQLite easier and more enjoyable. To put it bluntly, the official download
Posted on2012-03-09 07:36 Stephen_liu Read (11956) Comments (22) Edit Collection In the actual application, SQLite, as the most popular open-source embedded relational database, is playing an increasingly important role in the architecture design
This article is based on http://sqlite.org/arch.html.This document describes the architecture of the SQLite library. This is useful for those who want to understand and modify the internal structure of SQLite. Before exploring, we first download the
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.