在线文档教程

首页技术教程开发文档觅分类 ICON图标

技术教程开发文档觅分类 ICON图标

Immutable 3.8.1

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

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

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

Last Insert Rowid

List Of SQLite Constants

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 Methods Object

Mutex Verification Routines

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 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 Open File Handle

Overload A Function For A Virtual Table

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

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

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

数据库文件表 | Database File Format

数据类 | Datatypes

动态内存分配 | Dynamic Memory Allocation

外键约束 | Foreign Key Constraints

全文索引 | Full-Text Search

损坏方式 | How To Corrupt

语言 | Language

局限性 | Limits

锁定和并发 | Locking and Concurrency

其他 | Miscellaneous

PRAGMA Statements

查询计划程序 | Query Planner

语法图 | Syntax Diagrams

虚拟表机制 | Virtual Table Mechanism

预写日志 | Write-Ahead Logging

TensorFlow Guide

Storm入门教程

Hibernate 教程

Write Data Into A BLOB Incrementally

Write Data Into A BLOB Incrementally

int sqlite3_blob_write(sqlite3_blob *, const void *z, int n, int iOffset

该函数用于将数据写入来自调用者提供的缓冲区的开放BLOB句柄。将N字节的数据从缓冲区Z复制到打开的BLOB中，从偏移量iOffset开始。

成功时，sqlite3_blob_write()返回SQLITE_OK。否则，将返回错误代码或扩展错误代码。除非返回SQLITE_MISUSE，否则此函数将通过sqlite3_errcode()和sqlite3_errmsg()及相关函数设置数据库连接错误代码和消息。

如果作为第一个参数传递的BLOB句柄没有打开写入（flag参数为sqlite3_blob_open()为零），则此函数返回SQLITE_READONLY。

这个函数只能修改BLOB的内容; 使用此API无法增加BLOB的大小。如果偏移量iOffset小于BLOB末尾的N个字节，则返回SQLITE_ERROR并且不写入数据。BLOB的大小（以及因此N + iOffset的最大值）可以使用sqlite3_blob_bytes()接口确定。如果N或iOffset小于零，则返回SQLITE_ERROR并且不写入数据。

尝试写入到期的BLOB句柄失败，错误代码为SQLITE_ABORT。写入发生在BLOB句柄过期之前的BLOB不会在句柄到期时回滚，当然这些更改可能已被BLOB句柄过期的语句或其他独立语句覆盖。

此例程仅适用于通过先前成功调用sqlite3_blob_open()创建且尚未由sqlite3_blob_close()关闭的BLOB句柄。将任何其他指针传递给此例程会导致未定义且可能不合意的行为。

 SQLite is in the Public Domain.