capi3ref.html

sqlite的帮助文档

"<a href="capi3ref.html"><small><i>(obs)</i></small></a>" are <a href="capi3ref.html">deprecated</a></p>
<table width="100%" cellpadding="5"><tr><td valign="top"><ul><li><a href="#SQLITE_ABORT">SQLITE_ABORT</a></li><li><a href="#SQLITE_ACCESS_EXISTS">SQLITE_ACCESS_EXISTS</a></li><li><a href="#SQLITE_ACCESS_EXISTS">SQLITE_ACCESS_READ</a></li><li><a href="#SQLITE_ACCESS_EXISTS">SQLITE_ACCESS_READWRITE</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_ALTER_TABLE</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_ANALYZE</a></li><li><a href="#SQLITE_ANY">SQLITE_ANY</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_ATTACH</a></li><li><a href="#SQLITE_ABORT">SQLITE_AUTH</a></li><li><a href="#SQLITE_BLOB">SQLITE_BLOB</a></li><li><a href="#SQLITE_ABORT">SQLITE_BUSY</a></li><li><a href="#SQLITE_ABORT">SQLITE_CANTOPEN</a></li><li><a href="#SQLITE_CONFIG_GETMALLOC">SQLITE_CONFIG_GETMALLOC</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_CONFIG_GETMALLOC">SQLITE_CONFIG_GETMUTEX</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_CONFIG_GETMALLOC">SQLITE_CONFIG_HEAP</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_CONFIG_GETMALLOC">SQLITE_CONFIG_LOOKASIDE</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_CONFIG_GETMALLOC">SQLITE_CONFIG_MALLOC</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_CONFIG_GETMALLOC">SQLITE_CONFIG_MEMSTATUS</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_CONFIG_GETMALLOC">SQLITE_CONFIG_MULTITHREAD</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_CONFIG_GETMALLOC">SQLITE_CONFIG_MUTEX</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_CONFIG_GETMALLOC">SQLITE_CONFIG_PAGECACHE</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_CONFIG_GETMALLOC">SQLITE_CONFIG_SCRATCH</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_CONFIG_GETMALLOC">SQLITE_CONFIG_SERIALIZED</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_CONFIG_GETMALLOC">SQLITE_CONFIG_SINGLETHREAD</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_ABORT">SQLITE_CONSTRAINT</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_COPY</a></li><li><a href="#SQLITE_ABORT">SQLITE_CORRUPT</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_CREATE_INDEX</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_CREATE_TABLE</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_CREATE_TEMP_INDEX</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_CREATE_TEMP_TABLE</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_CREATE_TEMP_TRIGGER</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_CREATE_TEMP_VIEW</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_CREATE_TRIGGER</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_CREATE_VIEW</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_CREATE_VTABLE</a></li><li><a href="#SQLITE_DBCONFIG_LOOKASIDE">SQLITE_DBCONFIG_LOOKASIDE</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_DBSTATUS_LOOKASIDE_USED">SQLITE_DBSTATUS_LOOKASIDE_USED</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_DELETE</a></li><li><a href="#SQLITE_DENY">SQLITE_DENY</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_DETACH</a></li><li><a href="#SQLITE_ABORT">SQLITE_DONE</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_DROP_INDEX</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_DROP_TABLE</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_DROP_TEMP_INDEX</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_DROP_TEMP_TABLE</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_DROP_TEMP_TRIGGER</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_DROP_TEMP_VIEW</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_DROP_TRIGGER</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_DROP_VIEW</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_DROP_VTABLE</a></li><li><a href="#SQLITE_ABORT">SQLITE_EMPTY</a></li><li><a href="#SQLITE_ABORT">SQLITE_ERROR</a></li><li><a href="#SQLITE_FCNTL_LOCKSTATE">SQLITE_FCNTL_LOCKSTATE</a></li><li><a href="#SQLITE_BLOB">SQLITE_FLOAT</a></li><li><a href="#SQLITE_ABORT">SQLITE_FORMAT</a></li><li><a href="#SQLITE_ABORT">SQLITE_FULL</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_FUNCTION</a></li><li><a href="#SQLITE_DENY">SQLITE_IGNORE</a></li><li><a href="#SQLITE_INDEX_CONSTRAINT_EQ">SQLITE_INDEX_CONSTRAINT_EQ</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_INDEX_CONSTRAINT_EQ">SQLITE_INDEX_CONSTRAINT_GE</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_INDEX_CONSTRAINT_EQ">SQLITE_INDEX_CONSTRAINT_GT</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_INDEX_CONSTRAINT_EQ">SQLITE_INDEX_CONSTRAINT_LE</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_INDEX_CONSTRAINT_EQ">SQLITE_INDEX_CONSTRAINT_LT</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_INDEX_CONSTRAINT_EQ">SQLITE_INDEX_CONSTRAINT_MATCH</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_INSERT</a></li><li><a href="#SQLITE_BLOB">SQLITE_INTEGER</a></li><li><a href="#SQLITE_ABORT">SQLITE_INTERNAL</a></li><li><a href="#SQLITE_ABORT">SQLITE_INTERRUPT</a></li><li><a href="#SQLITE_IOCAP_ATOMIC">SQLITE_IOCAP_ATOMIC</a></li><li><a href="#SQLITE_IOCAP_ATOMIC">SQLITE_IOCAP_ATOMIC16K</a></li><li><a href="#SQLITE_IOCAP_ATOMIC">SQLITE_IOCAP_ATOMIC1K</a></li><li><a href="#SQLITE_IOCAP_ATOMIC">SQLITE_IOCAP_ATOMIC2K</a></li><li><a href="#SQLITE_IOCAP_ATOMIC">SQLITE_IOCAP_ATOMIC32K</a></li><li><a href="#SQLITE_IOCAP_ATOMIC">SQLITE_IOCAP_ATOMIC4K</a></li><li><a href="#SQLITE_IOCAP_ATOMIC">SQLITE_IOCAP_ATOMIC512</a></li><li><a href="#SQLITE_IOCAP_ATOMIC">SQLITE_IOCAP_ATOMIC64K</a></li><li><a href="#SQLITE_IOCAP_ATOMIC">SQLITE_IOCAP_ATOMIC8K</a></li><li><a href="#SQLITE_IOCAP_ATOMIC">SQLITE_IOCAP_SAFE_APPEND</a></li><li><a href="#SQLITE_IOCAP_ATOMIC">SQLITE_IOCAP_SEQUENTIAL</a></li><li><a href="#SQLITE_ABORT">SQLITE_IOERR</a></li><li><a href="#SQLITE_IOERR_ACCESS">SQLITE_IOERR_ACCESS</a></li><li><a href="#SQLITE_IOERR_ACCESS">SQLITE_IOERR_BLOCKED</a></li><li><a href="#SQLITE_IOERR_ACCESS">SQLITE_IOERR_CHECKRESERVEDLOCK</a></li><li><a href="#SQLITE_IOERR_ACCESS">SQLITE_IOERR_DELETE</a></li><li><a href="#SQLITE_IOERR_ACCESS">SQLITE_IOERR_DIR_FSYNC</a></li><li><a href="#SQLITE_IOERR_ACCESS">SQLITE_IOERR_FSTAT</a></li><li><a href="#SQLITE_IOERR_ACCESS">SQLITE_IOERR_FSYNC</a></li><li><a href="#SQLITE_IOERR_ACCESS">SQLITE_IOERR_LOCK</a></li><li><a href="#SQLITE_IOERR_ACCESS">SQLITE_IOERR_NOMEM</a></li><li><a href="#SQLITE_IOERR_ACCESS">SQLITE_IOERR_RDLOCK</a></li><li><a href="#SQLITE_IOERR_ACCESS">SQLITE_IOERR_READ</a></li><li><a href="#SQLITE_IOERR_ACCESS">SQLITE_IOERR_SHORT_READ</a></li></ul></td><td valign="top"><ul><li><a href="#SQLITE_IOERR_ACCESS">SQLITE_IOERR_TRUNCATE</a></li><li><a href="#SQLITE_IOERR_ACCESS">SQLITE_IOERR_UNLOCK</a></li><li><a href="#SQLITE_IOERR_ACCESS">SQLITE_IOERR_WRITE</a></li><li><a href="#SQLITE_LIMIT_ATTACHED">SQLITE_LIMIT_ATTACHED</a></li><li><a href="#SQLITE_LIMIT_ATTACHED">SQLITE_LIMIT_COLUMN</a></li><li><a href="#SQLITE_LIMIT_ATTACHED">SQLITE_LIMIT_COMPOUND_SELECT</a></li><li><a href="#SQLITE_LIMIT_ATTACHED">SQLITE_LIMIT_EXPR_DEPTH</a></li><li><a href="#SQLITE_LIMIT_ATTACHED">SQLITE_LIMIT_FUNCTION_ARG</a></li><li><a href="#SQLITE_LIMIT_ATTACHED">SQLITE_LIMIT_LENGTH</a></li><li><a href="#SQLITE_LIMIT_ATTACHED">SQLITE_LIMIT_LIKE_PATTERN_LENGTH</a></li><li><a href="#SQLITE_LIMIT_ATTACHED">SQLITE_LIMIT_SQL_LENGTH</a></li><li><a href="#SQLITE_LIMIT_ATTACHED">SQLITE_LIMIT_VARIABLE_NUMBER</a></li><li><a href="#SQLITE_LIMIT_ATTACHED">SQLITE_LIMIT_VDBE_OP</a></li><li><a href="#SQLITE_ABORT">SQLITE_LOCKED</a></li><li><a href="#SQLITE_LOCK_EXCLUSIVE">SQLITE_LOCK_EXCLUSIVE</a></li><li><a href="#SQLITE_LOCK_EXCLUSIVE">SQLITE_LOCK_NONE</a></li><li><a href="#SQLITE_LOCK_EXCLUSIVE">SQLITE_LOCK_PENDING</a></li><li><a href="#SQLITE_LOCK_EXCLUSIVE">SQLITE_LOCK_RESERVED</a></li><li><a href="#SQLITE_LOCK_EXCLUSIVE">SQLITE_LOCK_SHARED</a></li><li><a href="#SQLITE_ABORT">SQLITE_MISMATCH</a></li><li><a href="#SQLITE_ABORT">SQLITE_MISUSE</a></li><li><a href="#SQLITE_MUTEX_FAST">SQLITE_MUTEX_FAST</a></li><li><a href="#SQLITE_MUTEX_FAST">SQLITE_MUTEX_RECURSIVE</a></li><li><a href="#SQLITE_MUTEX_FAST">SQLITE_MUTEX_STATIC_LRU</a></li><li><a href="#SQLITE_MUTEX_FAST">SQLITE_MUTEX_STATIC_LRU2</a></li><li><a href="#SQLITE_MUTEX_FAST">SQLITE_MUTEX_STATIC_MASTER</a></li><li><a href="#SQLITE_MUTEX_FAST">SQLITE_MUTEX_STATIC_MEM</a></li><li><a href="#SQLITE_MUTEX_FAST">SQLITE_MUTEX_STATIC_MEM2</a></li><li><a href="#SQLITE_MUTEX_FAST">SQLITE_MUTEX_STATIC_PRNG</a></li><li><a href="#SQLITE_ABORT">SQLITE_NOLFS</a></li><li><a href="#SQLITE_ABORT">SQLITE_NOMEM</a></li><li><a href="#SQLITE_ABORT">SQLITE_NOTADB</a></li><li><a href="#SQLITE_ABORT">SQLITE_NOTFOUND</a></li><li><a href="#SQLITE_BLOB">SQLITE_NULL</a></li><li><a href="#SQLITE_ABORT">SQLITE_OK</a></li><li><a href="#SQLITE_OPEN_CREATE">SQLITE_OPEN_CREATE</a></li><li><a href="#SQLITE_OPEN_CREATE">SQLITE_OPEN_DELETEONCLOSE</a></li><li><a href="#SQLITE_OPEN_CREATE">SQLITE_OPEN_EXCLUSIVE</a></li><li><a href="#SQLITE_OPEN_CREATE">SQLITE_OPEN_FULLMUTEX</a></li><li><a href="#SQLITE_OPEN_CREATE">SQLITE_OPEN_MAIN_DB</a></li><li><a href="#SQLITE_OPEN_CREATE">SQLITE_OPEN_MAIN_JOURNAL</a></li><li><a href="#SQLITE_OPEN_CREATE">SQLITE_OPEN_MASTER_JOURNAL</a></li><li><a href="#SQLITE_OPEN_CREATE">SQLITE_OPEN_NOMUTEX</a></li><li><a href="#SQLITE_OPEN_CREATE">SQLITE_OPEN_READONLY</a></li><li><a href="#SQLITE_OPEN_CREATE">SQLITE_OPEN_READWRITE</a></li><li><a href="#SQLITE_OPEN_CREATE">SQLITE_OPEN_SUBJOURNAL</a></li><li><a href="#SQLITE_OPEN_CREATE">SQLITE_OPEN_TEMP_DB</a></li><li><a href="#SQLITE_OPEN_CREATE">SQLITE_OPEN_TEMP_JOURNAL</a></li><li><a href="#SQLITE_OPEN_CREATE">SQLITE_OPEN_TRANSIENT_DB</a></li><li><a href="#SQLITE_ABORT">SQLITE_PERM</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_PRAGMA</a></li><li><a href="#SQLITE_ABORT">SQLITE_PROTOCOL</a></li><li><a href="#SQLITE_ABORT">SQLITE_RANGE</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_READ</a></li><li><a href="#SQLITE_ABORT">SQLITE_READONLY</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_REINDEX</a></li><li><a href="#SQLITE_ABORT">SQLITE_ROW</a></li><li><a href="#SQLITE_ABORT">SQLITE_SCHEMA</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_SELECT</a></li><li><a href="#SQLITE_STATIC">SQLITE_STATIC</a></li><li><a href="#SQLITE_STATUS_MALLOC_SIZE">SQLITE_STATUS_MALLOC_SIZE</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_STATUS_MALLOC_SIZE">SQLITE_STATUS_MEMORY_USED</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_STATUS_MALLOC_SIZE">SQLITE_STATUS_PAGECACHE_OVERFLOW</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_STATUS_MALLOC_SIZE">SQLITE_STATUS_PAGECACHE_SIZE</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_STATUS_MALLOC_SIZE">SQLITE_STATUS_PAGECACHE_USED</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_STATUS_MALLOC_SIZE">SQLITE_STATUS_PARSER_STACK</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_STATUS_MALLOC_SIZE">SQLITE_STATUS_SCRATCH_OVERFLOW</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_STATUS_MALLOC_SIZE">SQLITE_STATUS_SCRATCH_SIZE</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_STATUS_MALLOC_SIZE">SQLITE_STATUS_SCRATCH_USED</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_STMTSTATUS_FULLSCAN_STEP">SQLITE_STMTSTATUS_FULLSCAN_STEP</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_STMTSTATUS_FULLSCAN_STEP">SQLITE_STMTSTATUS_SORT</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#SQLITE_SYNC_DATAONLY">SQLITE_SYNC_DATAONLY</a></li><li><a href="#SQLITE_SYNC_DATAONLY">SQLITE_SYNC_FULL</a></li><li><a href="#SQLITE_SYNC_DATAONLY">SQLITE_SYNC_NORMAL</a></li><li><a href="#SQLITE_TESTCTRL_BENIGN_MALLOC_HOOKS">SQLITE_TESTCTRL_BENIGN_MALLOC_HOOKS</a></li><li><a href="#SQLITE_TESTCTRL_BENIGN_MALLOC_HOOKS">SQLITE_TESTCTRL_BITVEC_TEST</a></li><li><a href="#SQLITE_TESTCTRL_BENIGN_MALLOC_HOOKS">SQLITE_TESTCTRL_FAULT_INSTALL</a></li><li><a href="#SQLITE_TESTCTRL_BENIGN_MALLOC_HOOKS">SQLITE_TESTCTRL_PRNG_RESET</a></li><li><a href="#SQLITE_TESTCTRL_BENIGN_MALLOC_HOOKS">SQLITE_TESTCTRL_PRNG_RESTORE</a></li><li><a href="#SQLITE_TESTCTRL_BENIGN_MALLOC_HOOKS">SQLITE_TESTCTRL_PRNG_SAVE</a></li><li><a href="#SQLITE_BLOB">SQLITE_TEXT</a></li><li><a href="#SQLITE_ABORT">SQLITE_TOOBIG</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_TRANSACTION</a></li><li><a href="#SQLITE_STATIC">SQLITE_TRANSIENT</a></li><li><a href="#SQLITE_ALTER_TABLE">SQLITE_UPDATE</a></li><li><a href="#SQLITE_ANY">SQLITE_UTF16</a></li><li><a href="#SQLITE_ANY">SQLITE_UTF16BE</a></li><li><a href="#SQLITE_ANY">SQLITE_UTF16LE</a></li><li><a href="#SQLITE_ANY">SQLITE_UTF16_ALIGNED</a></li><li><a href="#SQLITE_ANY">SQLITE_UTF8</a></li><li><a href="#SQLITE_VERSION">SQLITE_VERSION</a></li><li><a href="#SQLITE_VERSION">SQLITE_VERSION_NUMBER</a></li></ul></td></tr></table><hr>
<h2>Functions:</h2>
<p>Note: Functions marked with "<a href="capi3ref.html"><small><i>(exp)</i></small></a>"
are <a href="capi3ref.html">experimental</a> and functions marked with
<a href="capi3ref.html"><small><i>(obs)</i></small></a> are <a href="capi3ref.html">deprecated</a>.</p>
<table width="100%" cellpadding="5"><tr><td valign="top"><ul><li><a href="#sqlite3_aggregate_context">sqlite3_aggregate_context</a></li><li><a href="#sqlite3_aggregate_count">sqlite3_aggregate_count</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(obs)</i></small></a></li><li><a href="#sqlite3_auto_extension">sqlite3_auto_extension</a></li><li><a href="#sqlite3_bind_blob">sqlite3_bind_blob</a></li><li><a href="#sqlite3_bind_blob">sqlite3_bind_double</a></li><li><a href="#sqlite3_bind_blob">sqlite3_bind_int</a></li><li><a href="#sqlite3_bind_blob">sqlite3_bind_int64</a></li><li><a href="#sqlite3_bind_blob">sqlite3_bind_null</a></li><li><a href="#sqlite3_bind_parameter_count">sqlite3_bind_parameter_count</a></li><li><a href="#sqlite3_bind_parameter_index">sqlite3_bind_parameter_index</a></li><li><a href="#sqlite3_bind_parameter_name">sqlite3_bind_parameter_name</a></li><li><a href="#sqlite3_bind_blob">sqlite3_bind_text</a></li><li><a href="#sqlite3_bind_blob">sqlite3_bind_text16</a></li><li><a href="#sqlite3_bind_blob">sqlite3_bind_value</a></li><li><a href="#sqlite3_bind_blob">sqlite3_bind_zeroblob</a></li><li><a href="#sqlite3_blob_bytes">sqlite3_blob_bytes</a></li><li><a href="#sqlite3_blob_close">sqlite3_blob_close</a></li><li><a href="#sqlite3_blob_open">sqlite3_blob_open</a></li><li><a href="#sqlite3_blob_read">sqlite3_blob_read</a></li><li><a href="#sqlite3_blob_write">sqlite3_blob_write</a></li><li><a href="#sqlite3_busy_handler">sqlite3_busy_handler</a></li><li><a href="#sqlite3_busy_timeout">sqlite3_busy_timeout</a></li><li><a href="#sqlite3_changes">sqlite3_changes</a></li><li><a href="#sqlite3_clear_bindings">sqlite3_clear_bindings</a></li><li><a href="#sqlite3_close">sqlite3_close</a></li><li><a href="#sqlite3_collation_needed">sqlite3_collation_needed</a></li><li><a href="#sqlite3_collation_needed">sqlite3_collation_needed16</a></li><li><a href="#sqlite3_column_blob">sqlite3_column_blob</a></li><li><a href="#sqlite3_column_blob">sqlite3_column_bytes</a></li><li><a href="#sqlite3_column_blob">sqlite3_column_bytes16</a></li><li><a href="#sqlite3_column_count">sqlite3_column_count</a></li><li><a href="#sqlite3_column_database_name">sqlite3_column_database_name</a></li><li><a href="#sqlite3_column_database_name">sqlite3_column_database_name16</a></li><li><a href="#sqlite3_column_decltype">sqlite3_column_decltype</a></li><li><a href="#sqlite3_column_decltype">sqlite3_column_decltype16</a></li><li><a href="#sqlite3_column_blob">sqlite3_column_double</a></li><li><a href="#sqlite3_column_blob">sqlite3_column_int</a></li><li><a href="#sqlite3_column_blob">sqlite3_column_int64</a></li><li><a href="#sqlite3_column_name">sqlite3_column_name</a></li><li><a href="#sqlite3_column_name">sqlite3_column_name16</a></li><li><a href="#sqlite3_column_database_name">sqlite3_column_origin_name</a></li><li><a href="#sqlite3_column_database_name">sqlite3_column_origin_name16</a></li><li><a href="#sqlite3_column_database_name">sqlite3_column_table_name</a></li><li><a href="#sqlite3_column_database_name">sqlite3_column_table_name16</a></li><li><a href="#sqlite3_column_blob">sqlite3_column_text</a></li><li><a href="#sqlite3_column_blob">sqlite3_column_text16</a></li><li><a href="#sqlite3_column_blob">sqlite3_column_type</a></li><li><a href="#sqlite3_column_blob">sqlite3_column_value</a></li><li><a href="#sqlite3_commit_hook">sqlite3_commit_hook</a></li><li><a href="#sqlite3_complete">sqlite3_complete</a></li><li><a href="#sqlite3_complete">sqlite3_complete16</a></li><li><a href="#sqlite3_config">sqlite3_config</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#sqlite3_context_db_handle">sqlite3_context_db_handle</a></li><li><a href="#sqlite3_create_collation">sqlite3_create_collation</a></li><li><a href="#sqlite3_create_collation">sqlite3_create_collation16</a></li><li><a href="#sqlite3_create_collation">sqlite3_create_collation_v2</a></li><li><a href="#sqlite3_create_function">sqlite3_create_function</a></li><li><a href="#sqlite3_create_function">sqlite3_create_function16</a></li></ul></td><td valign="top"><ul><li><a href="#sqlite3_create_module">sqlite3_create_module</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#sqlite3_create_module_v2">sqlite3_create_module_v2</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#sqlite3_data_count">sqlite3_data_count</a></li><li><a href="#sqlite3_db_config">sqlite3_db_config</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#sqlite3_db_handle">sqlite3_db_handle</a></li><li><a href="#sqlite3_db_mutex">sqlite3_db_mutex</a></li><li><a href="#sqlite3_db_status">sqlite3_db_status</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#sqlite3_declare_vtab">sqlite3_declare_vtab</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#sqlite3_enable_load_extension">sqlite3_enable_load_extension</a></li><li><a href="#sqlite3_enable_shared_cache">sqlite3_enable_shared_cache</a></li><li><a href="#sqlite3_errcode">sqlite3_errcode</a></li><li><a href="#sqlite3_errcode">sqlite3_errmsg</a></li><li><a href="#sqlite3_errcode">sqlite3_errmsg16</a></li><li><a href="#sqlite3_exec">sqlite3_exec</a></li><li><a href="#sqlite3_aggregate_count">sqlite3_expired</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(obs)</i></small></a></li><li><a href="#sqlite3_errcode">sqlite3_extended_errcode</a></li><li><a href="#sqlite3_extended_result_codes">sqlite3_extended_result_codes</a></li><li><a href="#sqlite3_file_control">sqlite3_file_control</a></li><li><a href="#sqlite3_finalize">sqlite3_finalize</a></li><li><a href="#sqlite3_free">sqlite3_free</a></li><li><a href="#sqlite3_free_table">sqlite3_free_table</a></li><li><a href="#sqlite3_get_autocommit">sqlite3_get_autocommit</a></li><li><a href="#sqlite3_get_auxdata">sqlite3_get_auxdata</a></li><li><a href="#sqlite3_free_table">sqlite3_get_table</a></li><li><a href="#sqlite3_aggregate_count">sqlite3_global_recover</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(obs)</i></small></a></li><li><a href="#sqlite3_initialize">sqlite3_initialize</a></li><li><a href="#sqlite3_interrupt">sqlite3_interrupt</a></li><li><a href="#sqlite3_last_insert_rowid">sqlite3_last_insert_rowid</a></li><li><a href="#sqlite3_libversion">sqlite3_libversion</a></li><li><a href="#sqlite3_libversion">sqlite3_libversion_number</a></li><li><a href="#sqlite3_limit">sqlite3_limit</a></li><li><a href="#sqlite3_load_extension">sqlite3_load_extension</a></li><li><a href="#sqlite3_free">sqlite3_malloc</a></li><li><a href="#sqlite3_aggregate_count">sqlite3_memory_alarm</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(obs)</i></small></a></li><li><a href="#sqlite3_memory_highwater">sqlite3_memory_highwater</a></li><li><a href="#sqlite3_memory_highwater">sqlite3_memory_used</a></li><li><a href="#sqlite3_mprintf">sqlite3_mprintf</a></li><li><a href="#sqlite3_mutex_alloc">sqlite3_mutex_alloc</a></li><li><a href="#sqlite3_mutex_alloc">sqlite3_mutex_enter</a></li><li><a href="#sqlite3_mutex_alloc">sqlite3_mutex_free</a></li><li><a href="#sqlite3_mutex_held">sqlite3_mutex_held</a></li><li><a href="#sqlite3_mutex_alloc">sqlite3_mutex_leave</a></li><li><a href="#sqlite3_mutex_held">sqlite3_mutex_notheld</a></li><li><a href="#sqlite3_mutex_alloc">sqlite3_mutex_try</a></li><li><a href="#sqlite3_next_stmt">sqlite3_next_stmt</a></li><li><a href="#sqlite3_open">sqlite3_open</a></li><li><a href="#sqlite3_open">sqlite3_open16</a></li><li><a href="#sqlite3_open">sqlite3_open_v2</a></li><li><a href="#sqlite3_initialize">sqlite3_os_end</a></li><li><a href="#sqlite3_initialize">sqlite3_os_init</a></li><li><a href="#sqlite3_overload_function">sqlite3_overload_function</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#sqlite3_prepare">sqlite3_prepare</a></li><li><a href="#sqlite3_prepare">sqlite3_prepare16</a></li><li><a href="#sqlite3_prepare">sqlite3_prepare16_v2</a></li><li><a href="#sqlite3_prepare">sqlite3_prepare_v2</a></li><li><a href="#sqlite3_profile">sqlite3_profile</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#sqlite3_progress_handler">sqlite3_progress_handler</a></li><li><a href="#sqlite3_randomness">sqlite3_randomness</a></li></ul></td><td valign="top"><ul><li><a href="#sqlite3_free">sqlite3_realloc</a></li><li><a href="#sqlite3_release_memory">sqlite3_release_memory</a></li><li><a href="#sqlite3_reset">sqlite3_reset</a></li><li><a href="#sqlite3_reset_auto_extension">sqlite3_reset_auto_extension</a></li><li><a href="#sqlite3_result_blob">sqlite3_result_blob</a></li><li><a href="#sqlite3_result_blob">sqlite3_result_double</a></li><li><a href="#sqlite3_result_blob">sqlite3_result_error</a></li><li><a href="#sqlite3_result_blob">sqlite3_result_error16</a></li><li><a href="#sqlite3_result_blob">sqlite3_result_error_code</a></li><li><a href="#sqlite3_result_blob">sqlite3_result_error_nomem</a></li><li><a href="#sqlite3_result_blob">sqlite3_result_error_toobig</a></li><li><a href="#sqlite3_result_blob">sqlite3_result_int</a></li><li><a href="#sqlite3_result_blob">sqlite3_result_int64</a></li><li><a href="#sqlite3_result_blob">sqlite3_result_null</a></li><li><a href="#sqlite3_result_blob">sqlite3_result_text</a></li><li><a href="#sqlite3_result_blob">sqlite3_result_text16</a></li><li><a href="#sqlite3_result_blob">sqlite3_result_text16be</a></li><li><a href="#sqlite3_result_blob">sqlite3_result_text16le</a></li><li><a href="#sqlite3_result_blob">sqlite3_result_value</a></li><li><a href="#sqlite3_result_blob">sqlite3_result_zeroblob</a></li><li><a href="#sqlite3_commit_hook">sqlite3_rollback_hook</a></li><li><a href="#sqlite3_set_authorizer">sqlite3_set_authorizer</a></li><li><a href="#sqlite3_get_auxdata">sqlite3_set_auxdata</a></li><li><a href="#sqlite3_initialize">sqlite3_shutdown</a></li><li><a href="#sqlite3_sleep">sqlite3_sleep</a></li><li><a href="#sqlite3_mprintf">sqlite3_snprintf</a></li><li><a href="#sqlite3_soft_heap_limit">sqlite3_soft_heap_limit</a></li><li><a href="#sqlite3_sql">sqlite3_sql</a></li><li><a href="#sqlite3_status">sqlite3_status</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#sqlite3_step">sqlite3_step</a></li><li><a href="#sqlite3_stmt_status">sqlite3_stmt_status</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#sqlite3_table_column_metadata">sqlite3_table_column_metadata</a></li><li><a href="#sqlite3_test_control">sqlite3_test_control</a></li><li><a href="#sqlite3_aggregate_count">sqlite3_thread_cleanup</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(obs)</i></small></a></li><li><a href="#sqlite3_threadsafe">sqlite3_threadsafe</a></li><li><a href="#sqlite3_total_changes">sqlite3_total_changes</a></li><li><a href="#sqlite3_profile">sqlite3_trace</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(exp)</i></small></a></li><li><a href="#sqlite3_aggregate_count">sqlite3_transfer_bindings</a>&nbsp;&nbsp;<a href="capi3ref.html"><small><i>(obs)</i></small></a></li><li><a href="#sqlite3_update_hook">sqlite3_update_hook</a></li><li><a href="#sqlite3_user_data">sqlite3_user_data</a></li><li><a href="#sqlite3_value_blob">sqlite3_value_blob</a></li><li><a href="#sqlite3_value_blob">sqlite3_value_bytes</a></li><li><a href="#sqlite3_value_blob">sqlite3_value_bytes16</a></li><li><a href="#sqlite3_value_blob">sqlite3_value_double</a></li><li><a href="#sqlite3_value_blob">sqlite3_value_int</a></li><li><a href="#sqlite3_value_blob">sqlite3_value_int64</a></li><li><a href="#sqlite3_value_blob">sqlite3_value_numeric_type</a></li><li><a href="#sqlite3_value_blob">sqlite3_value_text</a></li><li><a href="#sqlite3_value_blob">sqlite3_value_text16</a></li><li><a href="#sqlite3_value_blob">sqlite3_value_text16be</a></li><li><a href="#sqlite3_value_blob">sqlite3_value_text16le</a></li><li><a href="#sqlite3_value_blob">sqlite3_value_type</a></li><li><a href="#sqlite3_libversion">sqlite3_version</a></li><li><a href="#sqlite3_vfs_find">sqlite3_vfs_find</a></li><li><a href="#sqlite3_vfs_find">sqlite3_vfs_register</a></li><li><a href="#sqlite3_vfs_find">sqlite3_vfs_unregister</a></li><li><a href="#sqlite3_mprintf">sqlite3_vmprintf</a></li></ul></td></tr></table><hr><a name="SQLITE_VERSION"></a>
<h2>Compile-Time Library Version Numbers</h2><blockquote><pre>#define SQLITE_VERSION         "3.6.5"
#define SQLITE_VERSION_NUMBER  3006005
</pre></blockquote><p>
The SQLITE_VERSION and SQLITE_VERSION_NUMBER #defines in
the sqlite3.h file specify the version of SQLite with which
that header file is associated.</p>

<p>The "version" of SQLite is a string of the form "X.Y.Z".
The phrase "alpha" or "beta" might be appended after the Z.
The X value is major version number always 3 in SQLite3.
The X value only changes when backwards compatibility is
broken and we intend to never break backwards compatibility.
The Y value is the minor version number and only changes when
there are major feature enhancements that are forwards compatible
but not backwards compatible.
The Z value is the release number and is incremented with
each release but resets back to 0 whenever Y is incremented.</p>

<p>See also: <a href="#sqlite3_libversion">sqlite3_libversion()</a> and <a href="#sqlite3_libversion">sqlite3_libversion_number()</a>.</p>

<p><h3>Invariants:</h3>
<table border="0" cellpadding="5" cellspacing="0">
<tr><td valign="top">H10011</td> 
<td valign="top">
The SQLITE_VERSION #define in the sqlite3.h header file shall
evaluate to a string literal that is the SQLite version
with which the header file is associated.</td></tr>
<tr><td valign="top">H10014</td> 
<td valign="top">
The SQLITE_VERSION_NUMBER #define shall resolve to an integer
with the value (X*1000000 + Y*1000 + Z) where X, Y, and Z
are the major version, minor version, and release number.</td></tr>
</table>
</p><hr><a name="SQLITE_CONFIG_GETMALLOC"></a>
<h2>Configuration Options</h2><blockquote><pre>#define SQLITE_CONFIG_SINGLETHREAD  1  /* nil */
#define SQLITE_CONFIG_MULTITHREAD   2  /* nil */
#define SQLITE_CONFIG_SERIALIZED    3  /* nil */
#define SQLITE_CONFIG_MALLOC        4  /* sqlite3_mem_methods* */
#define SQLITE_CONFIG_GETMALLOC     5  /* sqlite3_mem_methods* */
#define SQLITE_CONFIG_SCRATCH       6  /* void*, int sz, int N */
#define SQLITE_CONFIG_PAGECACHE     7  /* void*, int sz, int N */
#define SQLITE_CONFIG_HEAP          8  /* void*, int nByte, int min */
#define SQLITE_CONFIG_MEMSTATUS     9  /* boolean */
#define SQLITE_CONFIG_MUTEX        10  /* sqlite3_mutex_methods* */
#define SQLITE_CONFIG_GETMUTEX     11  /* sqlite3_mutex_methods* */
/* previously SQLITE_CONFIG_CHUNKALLOC 12 which is now unused. */ 
#define SQLITE_CONFIG_LOOKASIDE    13  /* int int */
</pre></blockquote><p><b>Important:</b> This interface is <a href="capi3ref.html">experimental</a> and is subject to change without notice.</p><p>
These constants are the available integer configuration options that
can be passed as the first argument to the <a href="#sqlite3_config">sqlite3_config()</a> interface.</p>

<p>New configuration options may be added in future releases of SQLite.
Existing configuration options might be discontinued.  Applications
should check the return code from <a href="#sqlite3_config">sqlite3_config()</a> to make sure that
the call worked.  The <a href="#sqlite3_config">sqlite3_config()</a> interface will return a
non-zero <a href="#SQLITE_ABORT">error code</a> if a discontinued or unsupported configuration option
is invoked.</p>

<p><dl>
<dt>SQLITE_CONFIG_SINGLETHREAD</dt>
<dd>There are no arguments to this option.  This option disables
all mutexing and puts SQLite into a mode where it can only be used
by a single thread.</dd></p>

<p><dt>SQLITE_CONFIG_MULTITHREAD</dt>
<dd>There are no arguments to this option.  This option disables
mutexing on <a href="#sqlite3">database connection</a> and <a href="#sqlite3_stmt">prepared statement</a> objects.
The application is responsible for serializing access to
<a href="#sqlite3">database connections</a> and <a href="#sqlite3_stmt">prepared statements</a>.  But other mutexes
are enabled so that SQLite will be safe to use in a multi-threaded
environment as long as no two threads attempt to use the same
<a href="#sqlite3">database connection</a> at the same time.  See the <a href="threadsafe.html">threading mode</a>
documentation for additional information.</dd></p>

<p><dt>SQLITE_CONFIG_SERIALIZED</dt>
<dd>There are no arguments to this option.  This option enables
all mutexes including the recursive
mutexes on <a href="#sqlite3">database connection</a> and <a href="#sqlite3_stmt">prepared statement</a> objects.
In this mode (which is the default when SQLite is compiled with
<a href="compile.html#threadsafe">SQLITE_THREADSAFE=1</a>) the SQLite library will itself serialize access
to <a href="#sqlite3">database connections</a> and <a href="#sqlite3_stmt">prepared statements</a> so that the
application is free to use the same <a href="#sqlite3">database connection</a> or the
same <a href="#sqlite3_stmt">prepared statement</a> in different threads at the same time.
See the <a href="threadsafe.html">threading mode</a> documentation for additional information.</dd></p>

<p><dt>SQLITE_CONFIG_MALLOC</dt>
<dd>This option takes a single argument which is a pointer to an
instance of the <a href="#sqlite3_mem_methods">sqlite3_mem_methods</a> structure.  The argument specifies
alternative low-level memory allocation routines to be used in place of
the memory allocation routines built into SQLite.</dd></p>

<p><dt>SQLITE_CONFIG_GETMALLOC</dt>
<dd>This option takes a single argument which is a pointer to an
instance of the <a href="#sqlite3_mem_methods">sqlite3_mem_methods</a> structure.  The <a href="#sqlite3_mem_methods">sqlite3_mem_methods</a>
structure is filled with the currently defined memory allocation routines.
This option can be used to overload the default memory allocation
routines with a wrapper that simulations memory allocation failure or
tracks memory usage, for example.</dd></p>

<p><dt>SQLITE_CONFIG_MEMSTATUS</dt>
<dd>This option takes single argument of type int, interpreted as a
boolean, which enables or disables the collection of memory allocation
statistics. When disabled, the following SQLite interfaces become
non-operational:
<ul>
<li> <a href="#sqlite3_memory_highwater">sqlite3_memory_used()</a>
<li> <a href="#sqlite3_memory_highwater">sqlite3_memory_highwater()</a>
<li> <a href="#sqlite3_soft_heap_limit">sqlite3_soft_heap_limit()</a>
<li> <a href="#sqlite3_status">sqlite3_status()</a>
</ul>
</dd></p>

<p><dt>SQLITE_CONFIG_SCRATCH</dt>
<dd>This option specifies a static memory buffer that SQLite can use for
scratch memory.  There are three arguments:  A pointer to the memory, the
size of each scratch buffer (sz), and the number of buffers (N).  The sz
argument must be a multiple of 16. The sz parameter should be a few bytes
larger than the actual scratch space required due internal overhead.
The first
argument should point to an allocation of at least sz*N bytes of memory.
SQLite will use no more than one scratch buffer at once per thread, so
N should be set to the expected maximum number of threads.  The sz
parameter should be 6 times the size of the largest database page size.
Scratch buffers are used as part of the btree balance operation.  If
The btree balancer needs additional memory beyond what is provided by
scratch buffers or if no scratch buffer space is specified, then SQLite
goes to <a href="#sqlite3_free">sqlite3_malloc()</a> to obtain the memory it needs.</dd></p>

<p><dt>SQLITE_CONFIG_PAGECACHE</dt>
<dd>This option specifies a static memory buffer that SQLite can use for
the database page cache.  There are three arguments: A pointer to the
memory, the size of each page buffer (sz), and the number of pages (N).
The sz argument must be a power of two between 512 and 32768.  The first
argument should point to an allocation of at least sz*N bytes of memory.
SQLite will use the memory provided by the first argument to satisfy its
memory needs for the first N pages that it adds to cache.  If additional
page cache memory is needed beyond what is provided by this option, then
SQLite goes to <a href="#sqlite3_free">sqlite3_malloc()</a> for the additional storage space.
The implementation might use one or more of the N buffers to hold
memory accounting information. </dd></p>

<p><dt>SQLITE_CONFIG_HEAP</dt>