📄 capi3ref.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"><html><head><title>C/C++ Interface For SQLite Version 3</title><style type="text/css">body { margin: auto; font-family: "Verdana" "sans-serif"; padding: 8px 1%;}a { color: #45735f }a:visited { color: #734559 }.logo { position:absolute; margin:3px; }.tagline { float:right; text-align:right; font-style:italic; width:240px; margin:12px; margin-top:58px;}.toolbar { font-variant: small-caps; text-align: center; line-height: 1.6em; margin: 0; padding:1px 8px;}.toolbar a { color: white; text-decoration: none; padding: 6px 12px; }.toolbar a:visited { color: white; }.toolbar a:hover { color: #80a796; background: white; }.content { margin: 5%; }.content dt { font-weight:bold; }.content dd { margin-bottom: 25px; margin-left:20%; }.content ul { padding:0px; padding-left: 15px; margin:0px; }/* rounded corners */.se { background: url(images/se.png) 100% 100% no-repeat #80a796}.sw { background: url(images/sw.png) 0% 100% no-repeat }.ne { background: url(images/ne.png) 100% 0% no-repeat }.nw { background: url(images/nw.png) 0% 0% no-repeat }</style><meta http-equiv="content-type" content="text/html; charset=UTF-8"> </head><body><div><!-- container div to satisfy validator --><a href="index.html"><img class="logo" src="images/SQLite.gif" alt="SQLite Logo" border="0"></a><div><!-- IE hack to prevent disappearing logo--></div><div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div><table width=100% style="clear:both"><tr><td> <div class="se"><div class="sw"><div class="ne"><div class="nw"> <div class="toolbar"> <a href="about.html">About</a> <a href="sitemap.html">Sitemap</a> <a href="docs.html">Documentation</a> <a href="download.html">Download</a> <a href="copyright.html">License</a> <a href="news.html">News</a> <a href="http://www.sqlite.org/cvstrac/index">Developers</a> <a href="support.html">Support</a> </div></div></div></div></div></td></tr></table> <h2 class=pdf_section>C/C++ Interface For SQLite Version 3</h2><p>This page defined the C-language interface to SQLite.</p><p>This is not a tutorial. Thesepages are designed to be precise, not easy to read.For a tutorial introduction see<a href="quickstart.html">SQLite In 3 Minutes Or Less</a> and/orthe <a href="cintro.html">Introduction To The SQLite C/C++ Interface</a>.</p><p>This page contains all C-language interface informationin a single HTML file. The same information is alsoavailable broken out into <a href="c3ref/intro.html">lots of small pages</a>for easier viewing, if you prefer.</p><p>This document is created by a script which scans commentsin the source code files.</p><hr><h2>Objects:</h2><table width="100%" cellpadding="5"><tr><td valign="top"><ul><li><a href="#sqlite3">sqlite3</a></li><li><a href="#sqlite3_int64">sqlite3_int64</a></li><li><a href="#sqlite3_int64">sqlite3_uint64</a></li><li><a href="#sqlite3_int64">sqlite_int64</a></li><li><a href="#sqlite3_int64">sqlite_uint64</a></li></ul></td><td valign="top"><ul><li><a href="#sqlite3_file">sqlite3_file</a></li><li><a href="#sqlite3_io_methods">sqlite3_io_methods</a></li><li><a href="#sqlite3_mutex">sqlite3_mutex</a></li><li><a href="#sqlite3_vfs">sqlite3_vfs</a></li><li><a href="#sqlite3_stmt">sqlite3_stmt</a></li></ul></td><td valign="top"><ul><li><a href="#sqlite3_value">sqlite3_value</a></li><li><a href="#sqlite3_context">sqlite3_context</a></li><li><a href="#sqlite3_temp_directory">sqlite3_temp_directory</a></li><li><a href="#sqlite3_blob">sqlite3_blob</a></li></ul></td></tr></table><hr><h2>Constants:</h2><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_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_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_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_BLOCKED">SQLITE_IOERR_BLOCKED</a></li><li><a href="#SQLITE_IOERR_BLOCKED">SQLITE_IOERR_DELETE</a></li><li><a href="#SQLITE_IOERR_BLOCKED">SQLITE_IOERR_DIR_FSYNC</a></li><li><a href="#SQLITE_IOERR_BLOCKED">SQLITE_IOERR_FSTAT</a></li><li><a href="#SQLITE_IOERR_BLOCKED">SQLITE_IOERR_FSYNC</a></li><li><a href="#SQLITE_IOERR_BLOCKED">SQLITE_IOERR_NOMEM</a></li><li><a href="#SQLITE_IOERR_BLOCKED">SQLITE_IOERR_RDLOCK</a></li><li><a href="#SQLITE_IOERR_BLOCKED">SQLITE_IOERR_READ</a></li><li><a href="#SQLITE_IOERR_BLOCKED">SQLITE_IOERR_SHORT_READ</a></li><li><a href="#SQLITE_IOERR_BLOCKED">SQLITE_IOERR_TRUNCATE</a></li><li><a href="#SQLITE_IOERR_BLOCKED">SQLITE_IOERR_UNLOCK</a></li><li><a href="#SQLITE_IOERR_BLOCKED">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></ul></td><td valign="top"><ul><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_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_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>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -