Sqlite参考手册

C界面 | C Interface

	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	详细

Sqlite

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

主页	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