非常教程

Sqlite参考手册

SQLite，是一款轻型的数据库，是遵守ACID的关系型数据库管理系统，它包含在一个相对小的C库中。它是D.RichardHipp建立的公有领域项目。它的设计目标是嵌入式的，而且目前已经在很多嵌入式产品中使用了它，它占用资源非常的低，在嵌入式设备中，可能只需要几百K的内存就够了。它能够支持Windows/Linux/Unix等等主流的操作系统，同时能够跟很多程序语言相结合，比如 Tcl、C#、PHP、Java等，还有ODBC接口，同样比起Mysql、PostgreSQL这两款开源的世界著名数据库管理系统来

C界面 | C Interface
64-Bit Integer Types 详细
A Handle To An Open BLOB 详细
An Introduction To The SQLite C/C++ Interface 详细
Application Defined Page Cache 详细
Attempt To Free Heap Memory 详细
Authorizer Action Codes 详细
Authorizer Return Codes 详细
Automatically Load Statically Linked Extensions 详细
Binding Values To Prepared Statements 详细
C/C++ Interface For SQLite Version 3 详细
C/C++ Interface For SQLite Version 3 (old) 详细
Cancel Automatic Extension Loading 详细
Checkpoint a database 详细
Checkpoint Mode Values 详细
Close A BLOB Handle 详细
Closing A Database Connection 详细
Collation Needed Callbacks 详细
Column Names In A Result Set 详细
Commit And Rollback Notification Callbacks 详细
Compare the ages of two snapshot handles 详细
Compile-Time Authorization Callbacks 详细
Compile-Time Library Version Numbers 详细
Compiling An SQL Statement 详细
Configuration Options 详细
Configure an auto-checkpoint 详细
Configure database connections 详细
Configuring The SQLite Library 详细
Conflict resolution modes 详细
Constants Defining Special Destructor Behavior 详细
Convenience Routines For Running Queries 详细
Copy And Free SQL Values 详细
Count The Number Of Rows Modified 详细
Create Or Redefine SQL Functions 详细
Custom Page Cache Object 详细
Data Change Notification Callbacks 详细
Database Connection Configuration Options 详细
Database Connection For Functions 详细
Database Connection Handle 详细
Database Connection Status 详细
Database Snapshot 详细
Declare The Schema Of A Virtual Table 详细
Declared Datatype Of A Query Result 详细
Define New Collating Sequences 详细
Deprecated Functions 详细
Deprecated Soft Heap Limit Interface 详细
Destroy A Prepared Statement Object 详细
Destroy a snapshot 详细
Determine if a database is read-only 详细
Determine If A Prepared Statement Has Been Reset 详细
Determine If An SQL Statement Is Complete 详细
Determine If An SQL Statement Writes The Database 详细
Determine The Virtual Table Conflict Policy 详细
Device Characteristics 详细
Dynamically Typed Value Object 详细
Enable Or Disable Extended Result Codes 详细
Enable Or Disable Extension Loading 详细
Enable Or Disable Shared Pager Cache 详细
Error Codes And Messages 详细
Error Logging Interface 详细
Evaluate An SQL Statement 详细
Experimental Interfaces 详细
Extended Result Codes 详细
Extract Metadata About A Column Of A Table 详细
File Locking Levels 详细
Find The Database Handle Of A Prepared Statement 详细
Find the next prepared statement 详细
Finding The Subtype Of SQL Values 详细
Flags For File Open Operations 详细
Flags for the xAccess VFS method 详细
Flags for the xShmLock VFS method 详细
Flush caches to disk mid-transaction 详细
Formatted String Printing Functions 详细
Free Memory Used By A Database Connection 详细
Function Auxiliary Data 详细
Function Flags 详细
Fundamental Datatypes 详细
Impose A Limit On Heap Size 详细
Index Of A Parameter With A Given Name 详细
Initialize The SQLite Library 详细
Interrupt A Long-Running Query 详细
Introduction 详细
Last Insert Rowid 详细
List Of SQLite Constants 详细
List Of SQLite Functions 详细
List Of SQLite Objects 详细
Load An Extension 详细
Loadable Extension Thunk 详细
Low-Level Control Of Database Files 详细
Low-level system error code 详细
Maximum xShmLock index 详细
Memory Allocation Routines 详细
Memory Allocation Subsystem 详细
Memory Allocator Statistics 详细
Move a BLOB Handle to a New Row 详细
Mutex Handle 详细
Mutex Methods Object 详细
Mutex Types 详细
Mutex Verification Routines 详细
Mutexes 详细
Name Of A Host Parameter 详细
Name Of The Folder Holding Database Files 详细
Name Of The Folder Holding Temporary Files 详细
Number Of Columns In A Result Set 详细
Number Of SQL Parameters 详细
Obtain Aggregate Function Context 详细
Obtain Values For URI Parameters 详细
Obtaining SQL Values 详细
One-Step Query Execution Interface 详细
Online Backup API 详细
Online Backup Object 详细
Open A BLOB For Incremental I/O 详细
Opening A New Database Connection 详细
OS Interface File Virtual Methods Object 详细
OS Interface Object 详细
OS Interface Open File Handle 详细
Overload A Function For A Virtual Table 详细
Prepare Flags 详细
Prepared Statement Object 详细
Prepared Statement Scan Status 详细
Prepared Statement Scan Status Opcodes 详细
Prepared Statement Status 详细
Pseudo-Random Number Generator 详细
Query Progress Callbacks 详细
Read Data From A BLOB Incrementally 详细
Record A Database Snapshot 详细
Recover snapshots from a wal file 详细
Register A Callback To Handle SQLITE_BUSY Errors 详细
Register A Virtual Table Implementation 详细
Reset A Prepared Statement Object 详细
Reset All Bindings On A Prepared Statement 详细
Reset Automatic Extension Loading 详细
Result Codes 详细
Result Values From A Query 详细
Retrieve the mutex for a database connection 详细
Retrieving Statement SQL 详细
Return The Filename For A Database Connection 详细
Return The Size Of An Open BLOB 详细
Run-Time Library Compilation Options Diagnostics 详细
Run-Time Library Version Numbers 详细
Run-Time Limit Categories 详细
Run-time Limits 详细
Set A Busy Timeout 详细
Set the Last Insert Rowid value 详细
Setting The Result Of An SQL Function 详细
Setting The Subtype Of An SQL Function 详细
Source Of Data In A Query Result 详细
SQL Function Context Object 详细
SQL Trace Event Codes 详细
SQL Trace Hook 详细
SQLite Runtime Status 详细
Standard File Control Opcodes 详细
Start a read transaction on an historical snapshot 详细
Status Parameters 详细
Status Parameters for database connections 详细
Status Parameters for prepared statements 详细
String Comparison 详细
String Globbing 详细
String LIKE Matching 详细
Suspend Execution For A Short Time 详细
Synchronization Type Flags 详细
Test For Auto-Commit Mode 详细
Test To See If The Library Is Threadsafe 详细
Testing Interface 详细
Testing Interface Operation Codes 详细
Text Encodings 详细
The C language interface to SQLite Version 2 详细
The Carray() Table-Valued Function 详细
The pre-update hook 详细
Total Number Of Rows Modified 详细
Tracing And Profiling Functions 详细
Unlock Notification 详细
User Data For Functions 详细
Virtual File System Objects 详细
Virtual Table Configuration Options 详细
Virtual Table Constraint Operator Codes 详细
Virtual Table Cursor Object 详细
Virtual Table Indexing Information 详细
Virtual Table Instance Object 详细
Virtual Table Interface Configuration 详细
Virtual Table Object 详细
Virtual Table Scan Flags 详细
Write Data Into A BLOB Incrementally 详细
Write-Ahead Log Commit Hook 详细
Zero Scan-Status Counters 详细
C Interface: Session Module
Add A Changeset To A Changegroup 详细
Advance A Changeset Iterator 详细
Apply A Changeset To A Database 详细
Attach A Table To A Session Object 详细
Changegroup Handle 详细
Changeset Iterator Handle 详细
Concatenate Two Changeset Objects 详细
Constants Passed To The Conflict Handler 详细
Constants Returned By The Conflict Handler 详细
Create A New Changegroup Object 详细
Create A New Session Object 详细
Create An Iterator To Traverse A Changeset 详细
Delete A Changegroup Object 详细
Delete A Session Object 详细
Determine The Number Of Foreign Key Constraint Violations 详细
Enable Or Disable A Session Object 详细
Finalize A Changeset Iterator 详细
Generate A Changeset From A Session Object 详细
Generate A Patchset From A Session Object 详细
Invert A Changeset 详细
Load The Difference Between Tables Into A Session 详细
Obtain A Composite Changeset From A Changegroup 详细
Obtain Conflicting Row Values From A Changeset Iterator 详细
Obtain new.* Values From A Changeset Iterator 详细
Obtain old.* Values From A Changeset Iterator 详细
Obtain The Current Operation From A Changeset Iterator 详细
Obtain The Primary Key Definition Of A Table 详细
Session Object Handle 详细
Set a table filter on a Session Object 详细
Set Or Clear the Indirect Change Flag 详细
SQLite Session Module C/C++ Interface 详细
Streaming Versions of API functions 详细
Test if a changeset has recorded any changes 详细
The Session Extension 详细
CLI
Command Line Shell For SQLite 详细
数据库文件表 | Database File Format
Database File Format 详细
数据类 | Datatypes
Datatypes In SQLite version 2 详细
Datatypes In SQLite Version 3 详细
动态内存分配 | Dynamic Memory Allocation
Dynamic Memory Allocation In SQLite 详细
外键约束 | Foreign Key Constraints
SQLite Foreign Key Support 详细
全文索引 | Full-Text Search
SQLite FTS3 and FTS4 Extensions 详细
SQLite FTS5 Extension 详细
损坏方式 | How To Corrupt
How To Corrupt An SQLite Database File 详细
JSON
The JSON1 Extension 详细
语言 | Language
Aggregate Functions 详细
ALTER TABLE 详细
ANALYZE 详细
ATTACH DATABASE 详细
BEGIN TRANSACTION 详细
comment 详细
Core Functions 详细
CREATE INDEX 详细
CREATE TABLE 详细
CREATE TRIGGER 详细
CREATE VIEW 详细
CREATE VIRTUAL TABLE 详细
Database Object Name Resolution 详细
Date And Time Functions 详细
DELETE 详细
DETACH DATABASE 详细
DROP INDEX 详细
DROP TABLE 详细
DROP TRIGGER 详细
DROP VIEW 详细
EXPLAIN 详细
expression 详细
INDEXED BY 详细
INSERT 详细
ON CONFLICT clause 详细
Query Language Understood by SQLite 详细
REINDEX 详细
REPLACE 详细
SAVEPOINT 详细
SELECT 详细
SQLite Keywords 详细
UPDATE 详细
VACUUM 详细
WITH clause 详细
局限性 | Limits
Implementation Limits For SQLite 详细
锁定和并发 | Locking and Concurrency
File Locking And Concurrency In SQLite Version 3 详细
其他 | Miscellaneous
35% Faster Than The Filesystem 详细
8+3 Filenames 详细
An Asynchronous I/O Module For SQLite 详细
Appropriate Uses For SQLite 详细
Architecture of SQLite 详细
Atomic Commit In SQLite 详细
Automatic Undo/Redo With SQLite 详细
Benefits of SQLite As A File Format 详细
Change in Default Page Size in SQLite Version 3.12.0 详细
Clustered Indexes and the WITHOUT ROWID Optimization 详细
Compile-time Options 详细
Constraint Conflict Resolution in SQLite 详细
Custom Builds Of SQLite 详细
Deterministic SQL Functions 详细
Distinctive Features Of SQLite 详细
EXPLAIN QUERY PLAN 详细
Features Of SQLite 详细
File Format Changes in SQLite 详细
Full-Featured SQL 详细
High Reliability 详细
Hints for Debugging SQLite 详细
How SQLite Is Tested 详细
How To Compile SQLite 详细
How To Download Canonical SQLite Source Code 详细
Imposter Tables 详细
In-Memory Databases 详细
Indexes On Expressions 详细
Internal Versus External BLOBs 详细
Isolation In SQLite 详细
Long Term Support 详细
Maintaining Private Branches Of SQLite 详细
Many Small Queries Are Efficient In SQLite 详细
Measuring and Reducing CPU Usage in SQLite 详细
Memory-Mapped I/O 详细
NULL Handling in SQLite 详细
Partial Indexes 详细
Pointer Passing Interfaces 详细
Powersafe Overwrite 详细
Release History Of SQLite 详细
Result and Error Codes 详细
Row Values 详细
Rowid Tables 详细
Run-Time Loadable Extensions 详细
SQL Features That SQLite Does Not Implement 详细
sqldiff.exe: Database Difference Utility 详细
SQLite As An Application File Format 详细
SQLite Autoincrement 详细
SQLite Backup API 详细
SQLite Changes From Version 3.4.2 To 3.5.0 详细
SQLite Changes From Version 3.5.9 To 3.6.0 详细
SQLite Database Speed Comparison 详细
SQLite File IO Specification 详细
SQLite Frequently Asked Questions 详细
SQLite In 5 Minutes Or Less 详细
SQLite is a Self Contained System 详细
SQLite Is Serverless 详细
SQLite Is Transactional 详细
SQLite Library Footprint 详细
SQLite Shared-Cache Mode 详细
SQLite Unlock-Notify API 详细
SQLite Version 3 Overview 详细
SQLite: Single File Database 详细
Temporary Files Used By SQLite 详细
TH3 详细
The COMPLETION() Table-Valued Function 详细
The CSV Virtual Table 详细
The dbhash.exe Utility Program 详细
The DBSTAT Virtual Table 详细
The Error And Warning Log 详细
The generate_series Table-Valued Function 详细
The OS Backend (VFS) To SQLite 详细
The Spellfix1 Virtual Table 详细
The SQLite Amalgamation 详细
The SQLite Bytecode Engine 详细
The sqlite3_analyzer.exe Utility Program 详细
The SQLITE_STMT Virtual Table 详细
The UNION Virtual Table 详细
The Virtual Database Engine of SQLite 详细
Uniform Resource Identifiers 详细
Using SQLite In Multi-Threaded Applications 详细
Version Numbers in SQLite 详细
What If OpenDocument Used SQLite? 详细
Why Is SQLite Coded In C 详细
Zero-Configuration 详细
PRAGMA Statements
Pragma statements supported by SQLite 详细
查询计划程序 | Query Planner
Query Planning 详细
The Next-Generation Query Planner 详细
The SQLite Query Optimizer Overview 详细
R*Tree Module
The SQLite R*Tree Module 详细
RBU Extension
The RBU Extension 详细
语法图 | Syntax Diagrams
SQLite Syntax: alter-table-stmt 详细
SQLite Syntax: analyze-stmt 详细
SQLite Syntax: attach-stmt 详细
SQLite Syntax: begin-stmt 详细
SQLite Syntax: column-constraint 详细
SQLite Syntax: column-def 详细
SQLite Syntax: column-name-list 详细
SQLite Syntax: comment-syntax 详细
SQLite Syntax: commit-stmt 详细
SQLite Syntax: common-table-expression 详细
SQLite Syntax: compound-operator 详细
SQLite Syntax: compound-select-stmt 详细
SQLite Syntax: conflict-clause 详细
SQLite Syntax: create-index-stmt 详细
SQLite Syntax: create-table-stmt 详细
SQLite Syntax: create-trigger-stmt 详细
SQLite Syntax: create-view-stmt 详细
SQLite Syntax: create-virtual-table-stmt 详细
SQLite Syntax: cte-table-name 详细
SQLite Syntax: delete-stmt 详细
SQLite Syntax: delete-stmt-limited 详细
SQLite Syntax: detach-stmt 详细
SQLite Syntax: drop-index-stmt 详细
SQLite Syntax: drop-table-stmt 详细
SQLite Syntax: drop-trigger-stmt 详细
SQLite Syntax: drop-view-stmt 详细
SQLite Syntax: expr 详细
SQLite Syntax: factored-select-stmt 详细
SQLite Syntax: foreign-key-clause 详细
SQLite Syntax: indexed-column 详细
SQLite Syntax: insert-stmt 详细
SQLite Syntax: join-clause 详细
SQLite Syntax: join-constraint 详细
SQLite Syntax: join-operator 详细
SQLite Syntax: literal-value 详细
SQLite Syntax: numeric-literal 详细
SQLite Syntax: ordering-term 详细
SQLite Syntax: pragma-stmt 详细
SQLite Syntax: pragma-value 详细
SQLite Syntax: qualified-table-name 详细
SQLite Syntax: raise-function 详细
SQLite Syntax: recursive-cte 详细
SQLite Syntax: reindex-stmt 详细
SQLite Syntax: release-stmt 详细
SQLite Syntax: result-column 详细
SQLite Syntax: rollback-stmt 详细
SQLite Syntax: savepoint-stmt 详细
SQLite Syntax: select-core 详细
SQLite Syntax: select-stmt 详细
SQLite Syntax: signed-number 详细
SQLite Syntax: simple-select-stmt 详细
SQLite Syntax: sql-stmt 详细
SQLite Syntax: sql-stmt-list 详细
SQLite Syntax: table-constraint 详细
SQLite Syntax: table-or-subquery 详细
SQLite Syntax: type-name 详细
SQLite Syntax: update-stmt 详细
SQLite Syntax: update-stmt-limited 详细
SQLite Syntax: vacuum-stmt 详细
SQLite Syntax: with-clause 详细
Syntax Diagrams For SQLite 详细
Tcl Interface
The Tcl interface to the SQLite library 详细
虚拟表机制 | Virtual Table Mechanism
The Virtual Table Mechanism Of SQLite 详细
预写日志 | Write-Ahead Logging
Write-Ahead Logging 详细
SQL 教程
SQL 简介
SQL 语法
SQL DELETE 语句
SQL UPDATE 语句
SQL NOT NULL 约束
SQL 约束
SQL CREATE TABLE 语句
SQL CREATE DATABASE 语句
SQL INSERT INTO SELECT 语句
SQL SELECT INTO 语句
SQL CREATE VIEW、REPLACE VIEW、 DROP VIEW 语句
SQL AUTO INCREMENT 字段
SQL ALTER TABLE 语句
SQL 撤销索引、表以及数据库
SQL CREATE INDEX 语句
SQL DEFAULT 约束
SQL CHECK 约束
SQL FOREIGN KEY 约束
SQL PRIMARY KEY 约束
SQL UNIQUE 约束
SQL 通用数据类型
SQL ISNULL()、NVL()、IFNULL() 和 COALESCE() 函数
SQL NULL 值 – IS NULL 和 IS NOT NULL
SQL Server 和 MySQL 中的 Date 函数
SQL MS Access、MySQL 和 SQL Server 数据类型
SQL 函数
SQL 总结
SQL 主机
SQL 快速参考
SQL ROUND() 函数
SQL Server GETDATE() 函数
MySQL DATE_FORMAT() 函数
MySQL DATEDIFF() 函数
MySQL DATE_SUB() 函数
MySQL DATE_ADD() 函数
MySQL EXTRACT() 函数
MySQL DATE() 函数
MySQL CURTIME() 函数
MySQL CURDATE() 函数
MySQL NOW() 函数
SQL Server CONVERT() 函数
SQL Server DATEDIFF() 函数
SQL Server DATEADD() 函数
SQL Server DATEPART() 函数
SQLite 命令
SQLite 安装
SQLite 简介
SQLite 运算符
SQLite Select 语句
SQLite 删除表
SQLite 创建表
SQLite Insert 语句
SQLite 分离数据库
SQLite 附加数据库
SQLite 创建数据库
SQLite 数据类型
SQLite 语法
SQLite Order By
SQLite Limit 子句
SQLite Glob 子句
SQLite Like 子句
SQLite Delete 语句
SQLite Update 语句
SQLite AND/OR 运算符
SQLite Where 子句
SQLite 表达式
SQLite Distinct 关键字
SQLite Having 子句
SQLite Group By
SQLite Join
SQLite 约束
SQLite PRAGMA
SQLite 事务
SQLite 视图
SQLite Truncate Table
SQLite Alter 命令
SQLite Indexed By
SQLite 索引
SQLite 触发器
SQLite 别名
SQLite NULL 值
SQLite Unions 子句
SQLite – PHP
SQLite – Java
SQLite – C/C++
SQLite 常用函数
SQLite 日期 & 时间
SQLite Vacuum
SQLite Explain
SQLite 注入
SQLite Autoincrement
SQLite 子查询
SQLite – Python
SQLite – Perl

Sqlite资料

主页 https://sqlite.org/
源码 https://www.sqlite.org/src/
发布版本 3.21.0

Sqlite目录

1.C界面 | C Interface
2.C Interface: Session Module
3.CLI
4.数据库文件表 | Database File Format
5.数据类 | Datatypes
6.动态内存分配 | Dynamic Memory Allocation
7.外键约束 | Foreign Key Constraints
8.全文索引 | Full-Text Search
9.损坏方式 | How To Corrupt
10.JSON
11.语言 | Language
12.局限性 | Limits
13.锁定和并发 | Locking and Concurrency
14.其他 | Miscellaneous
15.PRAGMA Statements
16.查询计划程序 | Query Planner
17.R*Tree Module
18.RBU Extension
19.语法图 | Syntax Diagrams
20.Tcl Interface
21.虚拟表机制 | Virtual Table Mechanism
22.预写日志 | Write-Ahead Logging
23.SQL 教程
24.SQL 简介
25.SQL 语法
26.SQL DELETE 语句
27.SQL UPDATE 语句
28.SQL NOT NULL 约束
29.SQL 约束
30.SQL CREATE TABLE 语句
31.SQL CREATE DATABASE 语句
32.SQL INSERT INTO SELECT 语句
33.SQL SELECT INTO 语句
34.SQL CREATE VIEW、REPLACE VIEW、 DROP VIEW 语句
35.SQL AUTO INCREMENT 字段
36.SQL ALTER TABLE 语句
37.SQL 撤销索引、表以及数据库
38.SQL CREATE INDEX 语句
39.SQL DEFAULT 约束
40.SQL CHECK 约束
41.SQL FOREIGN KEY 约束
42.SQL PRIMARY KEY 约束
43.SQL UNIQUE 约束
44.SQL 通用数据类型
45.SQL ISNULL()、NVL()、IFNULL() 和 COALESCE() 函数
46.SQL NULL 值 – IS NULL 和 IS NOT NULL
47.SQL Server 和 MySQL 中的 Date 函数
48.SQL MS Access、MySQL 和 SQL Server 数据类型
49.SQL 函数
50.SQL 总结
51.SQL 主机
52.SQL 快速参考
53.SQL ROUND() 函数
54.SQL Server GETDATE() 函数
55.MySQL DATE_FORMAT() 函数
56.MySQL DATEDIFF() 函数
57.MySQL DATE_SUB() 函数
58.MySQL DATE_ADD() 函数
59.MySQL EXTRACT() 函数
60.MySQL DATE() 函数
61.MySQL CURTIME() 函数
62.MySQL CURDATE() 函数
63.MySQL NOW() 函数
64.SQL Server CONVERT() 函数
65.SQL Server DATEDIFF() 函数
66.SQL Server DATEADD() 函数
67.SQL Server DATEPART() 函数
68.SQLite 命令
69.SQLite 安装
70.SQLite 简介
71.SQLite 运算符
72.SQLite Select 语句
73.SQLite 删除表
74.SQLite 创建表
75.SQLite Insert 语句
76.SQLite 分离数据库
77.SQLite 附加数据库
78.SQLite 创建数据库
79.SQLite 数据类型
80.SQLite 语法
81.SQLite Order By
82.SQLite Limit 子句
83.SQLite Glob 子句
84.SQLite Like 子句
85.SQLite Delete 语句
86.SQLite Update 语句
87.SQLite AND/OR 运算符
88.SQLite Where 子句
89.SQLite 表达式
90.SQLite Distinct 关键字
91.SQLite Having 子句
92.SQLite Group By
93.SQLite Join
94.SQLite 约束
95.SQLite PRAGMA
96.SQLite 事务
97.SQLite 视图
98.SQLite Truncate Table
99.SQLite Alter 命令
100.SQLite Indexed By

非常教程非常教程(www.verydoc.net)提供了编程的基础技术教程, 介绍了HTML、CSS、Javascript、Python，Java，Ruby，C，PHP , MySQL ,swift等各种编程语言的基础知识。 同时本站中也提供了大量的在线实例，通过实例，您可以更好的学习编程。

法律声明：本站内容均为网友上传，网站举办方负责审核和监督，如存在版权或非法内容，欢迎举报，我们将尽快予以删除。

Copyright © 2008-2017 非常教程. All rights reserved. Powered by iCMS V7.0.16.ICP备案号闽ICP备10001625号-55