1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
3
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
4
<title>List Of SQLite Functions</title>
5
<style type="text/css">
8
font-family: Verdana, sans-serif;
13
a:visited { color: #734559 }
15
.logo { position:absolute; margin:3px; }
31
.toolbar a { color: white; text-decoration: none; padding: 6px 12px; }
32
.toolbar a:visited { color: white; }
33
.toolbar a:hover { color: #044a64; background: white; }
35
.content { margin: 5%; }
36
.content dt { font-weight:bold; }
37
.content dd { margin-bottom: 25px; margin-left:20%; }
38
.content ul { padding:0px; padding-left: 15px; margin:0px; }
41
.se { background: url(../images/se.gif) 100% 100% no-repeat #044a64}
42
.sw { background: url(../images/sw.gif) 0% 100% no-repeat }
43
.ne { background: url(../images/ne.gif) 100% 0% no-repeat }
44
.nw { background: url(../images/nw.gif) 0% 0% no-repeat }
46
/* Things for "fancyformat" documents start here. */
47
.fancy img+p {font-style:italic}
48
.fancy .codeblock i { color: darkblue; }
49
.fancy h1,.fancy h2,.fancy h3,.fancy h4 {font-weight:normal;color:#044a64}
50
.fancy h2 { margin-left: 10px }
51
.fancy h3 { margin-left: 20px }
52
.fancy h4 { margin-left: 30px }
53
.fancy th {white-space:nowrap;text-align:left;border-bottom:solid 1px #444}
54
.fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top}
55
.fancy #toc a { color: darkblue ; text-decoration: none }
56
.fancy .todo { color: #AA3333 ; font-style : italic }
57
.fancy .todo:before { content: 'TODO:' }
58
.fancy p.todo { border: solid #AA3333 1px; padding: 1ex }
59
.fancy img { display:block; }
60
.fancy :link:hover, .fancy :visited:hover { background: wheat }
61
.fancy p,.fancy ul,.fancy ol { margin: 1em 5ex }
62
.fancy li p { margin: 1em 0 }
63
/* End of "fancyformat" specific rules. */
69
<div><!-- container div to satisfy validator -->
71
<a href="../index.html">
72
<img class="logo" src="../images/sqlite370_banner.gif" alt="SQLite Logo"
74
<div><!-- IE hack to prevent disappearing logo--></div>
75
<div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
77
<table width=100% style="clear:both"><tr><td>
78
<div class="se"><div class="sw"><div class="ne"><div class="nw">
79
<table width=100% style="padding:0;margin:0;cell-spacing:0"><tr>
82
<a href="../about.html">About</a>
83
<a href="../sitemap.html">Sitemap</a>
84
<a href="../docs.html">Documentation</a>
85
<a href="../download.html">Download</a>
86
<a href="../copyright.html">License</a>
87
<a href="../news.html">News</a>
88
<a href="../support.html">Support</a>
91
gMsg = "Search SQLite Docs..."
92
function entersearch() {
93
var q = document.getElementById("q");
94
if( q.value == gMsg ) { q.value = "" }
95
q.style.color = "black"
96
q.style.fontStyle = "normal"
98
function leavesearch() {
99
var q = document.getElementById("q");
100
if( q.value == "" ) {
102
q.style.color = "#044a64"
103
q.style.fontStyle = "italic"
108
<div style="padding:0 1em 0px 0;white-space:nowrap">
109
<form name=f method="GET" action="http://www.sqlite.org/search">
110
<input id=q name=q type=text
111
onfocus="entersearch()" onblur="leavesearch()" style="width:24ex;padding:1px 1ex; border:solid white 1px; font-size:0.9em ; font-style:italic;color:#044a64;" value="Search SQLite Docs...">
112
<input type=submit value="Go" style="border:solid white 1px;background-color:#044a64;color:white;font-size:0.9em;padding:0 1ex">
116
</div></div></div></div>
118
<div class=startsearch></div>
120
<a href="intro.html"><h2>SQLite C Interface</h2></a>
123
<p>Note: Functions marked with "<a href="../c3ref/experimental.html"><small><i>(exp)</i></small></a>"
124
are <a href="../c3ref/experimental.html">experimental</a> and functions marked with
125
<a href="../c3ref/experimental.html"><small><i>(obs)</i></small></a> are <a href="../c3ref/experimental.html">deprecated</a>.</p>
126
<table width="100%" cellpadding="5"><tr>
127
<td valign="top"><ul><li><a href="../c3ref/aggregate_context.html">sqlite3_aggregate_context</a></li>
128
<li><a href="../c3ref/aggregate_count.html">sqlite3_aggregate_count</a> <a href="../c3ref/experimental.html"><small><i>(obs)</i></small></a></li>
129
<li><a href="../c3ref/auto_extension.html">sqlite3_auto_extension</a></li>
130
<li><a href="../c3ref/backup_finish.html#sqlite3backupfinish">sqlite3_backup_finish</a></li>
131
<li><a href="../c3ref/backup_finish.html#sqlite3backupfinish">sqlite3_backup_init</a></li>
132
<li><a href="../c3ref/backup_finish.html#sqlite3backupfinish">sqlite3_backup_pagecount</a></li>
133
<li><a href="../c3ref/backup_finish.html#sqlite3backupfinish">sqlite3_backup_remaining</a></li>
134
<li><a href="../c3ref/backup_finish.html#sqlite3backupfinish">sqlite3_backup_step</a></li>
135
<li><a href="../c3ref/bind_blob.html">sqlite3_bind_blob</a></li>
136
<li><a href="../c3ref/bind_blob.html">sqlite3_bind_double</a></li>
137
<li><a href="../c3ref/bind_blob.html">sqlite3_bind_int</a></li>
138
<li><a href="../c3ref/bind_blob.html">sqlite3_bind_int64</a></li>
139
<li><a href="../c3ref/bind_blob.html">sqlite3_bind_null</a></li>
140
<li><a href="../c3ref/bind_parameter_count.html">sqlite3_bind_parameter_count</a></li>
141
<li><a href="../c3ref/bind_parameter_index.html">sqlite3_bind_parameter_index</a></li>
142
<li><a href="../c3ref/bind_parameter_name.html">sqlite3_bind_parameter_name</a></li>
143
<li><a href="../c3ref/bind_blob.html">sqlite3_bind_text</a></li>
144
<li><a href="../c3ref/bind_blob.html">sqlite3_bind_text16</a></li>
145
<li><a href="../c3ref/bind_blob.html">sqlite3_bind_value</a></li>
146
<li><a href="../c3ref/bind_blob.html">sqlite3_bind_zeroblob</a></li>
147
<li><a href="../c3ref/blob_bytes.html">sqlite3_blob_bytes</a></li>
148
<li><a href="../c3ref/blob_close.html">sqlite3_blob_close</a></li>
149
<li><a href="../c3ref/blob_open.html">sqlite3_blob_open</a></li>
150
<li><a href="../c3ref/blob_read.html">sqlite3_blob_read</a></li>
151
<li><a href="../c3ref/blob_reopen.html">sqlite3_blob_reopen</a></li>
152
<li><a href="../c3ref/blob_write.html">sqlite3_blob_write</a></li>
153
<li><a href="../c3ref/busy_handler.html">sqlite3_busy_handler</a></li>
154
<li><a href="../c3ref/busy_timeout.html">sqlite3_busy_timeout</a></li>
155
<li><a href="../c3ref/changes.html">sqlite3_changes</a></li>
156
<li><a href="../c3ref/clear_bindings.html">sqlite3_clear_bindings</a></li>
157
<li><a href="../c3ref/close.html">sqlite3_close</a></li>
158
<li><a href="../c3ref/collation_needed.html">sqlite3_collation_needed</a></li>
159
<li><a href="../c3ref/collation_needed.html">sqlite3_collation_needed16</a></li>
160
<li><a href="../c3ref/column_blob.html">sqlite3_column_blob</a></li>
161
<li><a href="../c3ref/column_blob.html">sqlite3_column_bytes</a></li>
162
<li><a href="../c3ref/column_blob.html">sqlite3_column_bytes16</a></li>
163
<li><a href="../c3ref/column_count.html">sqlite3_column_count</a></li>
164
<li><a href="../c3ref/column_database_name.html">sqlite3_column_database_name</a></li>
165
<li><a href="../c3ref/column_database_name.html">sqlite3_column_database_name16</a></li>
166
<li><a href="../c3ref/column_decltype.html">sqlite3_column_decltype</a></li>
167
<li><a href="../c3ref/column_decltype.html">sqlite3_column_decltype16</a></li>
168
<li><a href="../c3ref/column_blob.html">sqlite3_column_double</a></li>
169
<li><a href="../c3ref/column_blob.html">sqlite3_column_int</a></li>
170
<li><a href="../c3ref/column_blob.html">sqlite3_column_int64</a></li>
171
<li><a href="../c3ref/column_name.html">sqlite3_column_name</a></li>
172
<li><a href="../c3ref/column_name.html">sqlite3_column_name16</a></li>
173
<li><a href="../c3ref/column_database_name.html">sqlite3_column_origin_name</a></li>
174
<li><a href="../c3ref/column_database_name.html">sqlite3_column_origin_name16</a></li>
175
<li><a href="../c3ref/column_database_name.html">sqlite3_column_table_name</a></li>
176
<li><a href="../c3ref/column_database_name.html">sqlite3_column_table_name16</a></li>
177
<li><a href="../c3ref/column_blob.html">sqlite3_column_text</a></li>
178
<li><a href="../c3ref/column_blob.html">sqlite3_column_text16</a></li>
179
<li><a href="../c3ref/column_blob.html">sqlite3_column_type</a></li>
180
<li><a href="../c3ref/column_blob.html">sqlite3_column_value</a></li>
181
<li><a href="../c3ref/commit_hook.html">sqlite3_commit_hook</a></li>
182
<li><a href="../c3ref/compileoption_get.html">sqlite3_compileoption_get</a></li>
183
<li><a href="../c3ref/compileoption_get.html">sqlite3_compileoption_used</a></li>
184
<li><a href="../c3ref/complete.html">sqlite3_complete</a></li>
185
<li><a href="../c3ref/complete.html">sqlite3_complete16</a></li>
186
<li><a href="../c3ref/config.html">sqlite3_config</a></li>
187
<li><a href="../c3ref/context_db_handle.html">sqlite3_context_db_handle</a></li>
188
<li><a href="../c3ref/create_collation.html">sqlite3_create_collation</a></li>
189
<li><a href="../c3ref/create_collation.html">sqlite3_create_collation16</a></li>
190
<li><a href="../c3ref/create_collation.html">sqlite3_create_collation_v2</a></li>
191
<li><a href="../c3ref/create_function.html">sqlite3_create_function</a></li>
192
<li><a href="../c3ref/create_function.html">sqlite3_create_function16</a></li>
193
<li><a href="../c3ref/create_function.html">sqlite3_create_function_v2</a></li>
194
<li><a href="../c3ref/create_module.html">sqlite3_create_module</a></li>
196
<td valign="top"><ul><li><a href="../c3ref/create_module.html">sqlite3_create_module_v2</a></li>
197
<li><a href="../c3ref/data_count.html">sqlite3_data_count</a></li>
198
<li><a href="../c3ref/db_config.html">sqlite3_db_config</a></li>
199
<li><a href="../c3ref/db_filename.html">sqlite3_db_filename</a></li>
200
<li><a href="../c3ref/db_handle.html">sqlite3_db_handle</a></li>
201
<li><a href="../c3ref/db_mutex.html">sqlite3_db_mutex</a></li>
202
<li><a href="../c3ref/db_readonly.html">sqlite3_db_readonly</a></li>
203
<li><a href="../c3ref/db_release_memory.html">sqlite3_db_release_memory</a></li>
204
<li><a href="../c3ref/db_status.html">sqlite3_db_status</a></li>
205
<li><a href="../c3ref/declare_vtab.html">sqlite3_declare_vtab</a></li>
206
<li><a href="../c3ref/enable_load_extension.html">sqlite3_enable_load_extension</a></li>
207
<li><a href="../c3ref/enable_shared_cache.html">sqlite3_enable_shared_cache</a></li>
208
<li><a href="../c3ref/errcode.html">sqlite3_errcode</a></li>
209
<li><a href="../c3ref/errcode.html">sqlite3_errmsg</a></li>
210
<li><a href="../c3ref/errcode.html">sqlite3_errmsg16</a></li>
211
<li><a href="../c3ref/exec.html">sqlite3_exec</a></li>
212
<li><a href="../c3ref/aggregate_count.html">sqlite3_expired</a> <a href="../c3ref/experimental.html"><small><i>(obs)</i></small></a></li>
213
<li><a href="../c3ref/errcode.html">sqlite3_extended_errcode</a></li>
214
<li><a href="../c3ref/extended_result_codes.html">sqlite3_extended_result_codes</a></li>
215
<li><a href="../c3ref/file_control.html">sqlite3_file_control</a></li>
216
<li><a href="../c3ref/finalize.html">sqlite3_finalize</a></li>
217
<li><a href="../c3ref/free.html">sqlite3_free</a></li>
218
<li><a href="../c3ref/free_table.html">sqlite3_free_table</a></li>
219
<li><a href="../c3ref/get_autocommit.html">sqlite3_get_autocommit</a></li>
220
<li><a href="../c3ref/get_auxdata.html">sqlite3_get_auxdata</a></li>
221
<li><a href="../c3ref/free_table.html">sqlite3_get_table</a></li>
222
<li><a href="../c3ref/aggregate_count.html">sqlite3_global_recover</a> <a href="../c3ref/experimental.html"><small><i>(obs)</i></small></a></li>
223
<li><a href="../c3ref/initialize.html">sqlite3_initialize</a></li>
224
<li><a href="../c3ref/interrupt.html">sqlite3_interrupt</a></li>
225
<li><a href="../c3ref/last_insert_rowid.html">sqlite3_last_insert_rowid</a></li>
226
<li><a href="../c3ref/libversion.html">sqlite3_libversion</a></li>
227
<li><a href="../c3ref/libversion.html">sqlite3_libversion_number</a></li>
228
<li><a href="../c3ref/limit.html">sqlite3_limit</a></li>
229
<li><a href="../c3ref/load_extension.html">sqlite3_load_extension</a></li>
230
<li><a href="../c3ref/log.html">sqlite3_log</a></li>
231
<li><a href="../c3ref/free.html">sqlite3_malloc</a></li>
232
<li><a href="../c3ref/aggregate_count.html">sqlite3_memory_alarm</a> <a href="../c3ref/experimental.html"><small><i>(obs)</i></small></a></li>
233
<li><a href="../c3ref/memory_highwater.html">sqlite3_memory_highwater</a></li>
234
<li><a href="../c3ref/memory_highwater.html">sqlite3_memory_used</a></li>
235
<li><a href="../c3ref/mprintf.html">sqlite3_mprintf</a></li>
236
<li><a href="../c3ref/mutex_alloc.html">sqlite3_mutex_alloc</a></li>
237
<li><a href="../c3ref/mutex_alloc.html">sqlite3_mutex_enter</a></li>
238
<li><a href="../c3ref/mutex_alloc.html">sqlite3_mutex_free</a></li>
239
<li><a href="../c3ref/mutex_held.html">sqlite3_mutex_held</a></li>
240
<li><a href="../c3ref/mutex_alloc.html">sqlite3_mutex_leave</a></li>
241
<li><a href="../c3ref/mutex_held.html">sqlite3_mutex_notheld</a></li>
242
<li><a href="../c3ref/mutex_alloc.html">sqlite3_mutex_try</a></li>
243
<li><a href="../c3ref/next_stmt.html">sqlite3_next_stmt</a></li>
244
<li><a href="../c3ref/open.html">sqlite3_open</a></li>
245
<li><a href="../c3ref/open.html">sqlite3_open16</a></li>
246
<li><a href="../c3ref/open.html">sqlite3_open_v2</a></li>
247
<li><a href="../c3ref/initialize.html">sqlite3_os_end</a></li>
248
<li><a href="../c3ref/initialize.html">sqlite3_os_init</a></li>
249
<li><a href="../c3ref/overload_function.html">sqlite3_overload_function</a></li>
250
<li><a href="../c3ref/prepare.html">sqlite3_prepare</a></li>
251
<li><a href="../c3ref/prepare.html">sqlite3_prepare16</a></li>
252
<li><a href="../c3ref/prepare.html">sqlite3_prepare16_v2</a></li>
253
<li><a href="../c3ref/prepare.html">sqlite3_prepare_v2</a></li>
254
<li><a href="../c3ref/profile.html">sqlite3_profile</a></li>
255
<li><a href="../c3ref/progress_handler.html">sqlite3_progress_handler</a></li>
256
<li><a href="../c3ref/randomness.html">sqlite3_randomness</a></li>
257
<li><a href="../c3ref/free.html">sqlite3_realloc</a></li>
258
<li><a href="../c3ref/release_memory.html">sqlite3_release_memory</a></li>
259
<li><a href="../c3ref/reset.html">sqlite3_reset</a></li>
260
<li><a href="../c3ref/reset_auto_extension.html">sqlite3_reset_auto_extension</a></li>
261
<li><a href="../c3ref/result_blob.html">sqlite3_result_blob</a></li>
262
<li><a href="../c3ref/result_blob.html">sqlite3_result_double</a></li>
263
<li><a href="../c3ref/result_blob.html">sqlite3_result_error</a></li>
265
<td valign="top"><ul><li><a href="../c3ref/result_blob.html">sqlite3_result_error16</a></li>
266
<li><a href="../c3ref/result_blob.html">sqlite3_result_error_code</a></li>
267
<li><a href="../c3ref/result_blob.html">sqlite3_result_error_nomem</a></li>
268
<li><a href="../c3ref/result_blob.html">sqlite3_result_error_toobig</a></li>
269
<li><a href="../c3ref/result_blob.html">sqlite3_result_int</a></li>
270
<li><a href="../c3ref/result_blob.html">sqlite3_result_int64</a></li>
271
<li><a href="../c3ref/result_blob.html">sqlite3_result_null</a></li>
272
<li><a href="../c3ref/result_blob.html">sqlite3_result_text</a></li>
273
<li><a href="../c3ref/result_blob.html">sqlite3_result_text16</a></li>
274
<li><a href="../c3ref/result_blob.html">sqlite3_result_text16be</a></li>
275
<li><a href="../c3ref/result_blob.html">sqlite3_result_text16le</a></li>
276
<li><a href="../c3ref/result_blob.html">sqlite3_result_value</a></li>
277
<li><a href="../c3ref/result_blob.html">sqlite3_result_zeroblob</a></li>
278
<li><a href="../c3ref/commit_hook.html">sqlite3_rollback_hook</a></li>
279
<li><a href="../c3ref/set_authorizer.html">sqlite3_set_authorizer</a></li>
280
<li><a href="../c3ref/get_auxdata.html">sqlite3_set_auxdata</a></li>
281
<li><a href="../c3ref/initialize.html">sqlite3_shutdown</a></li>
282
<li><a href="../c3ref/sleep.html">sqlite3_sleep</a></li>
283
<li><a href="../c3ref/mprintf.html">sqlite3_snprintf</a></li>
284
<li><a href="../c3ref/soft_heap_limit.html">sqlite3_soft_heap_limit</a> <a href="../c3ref/experimental.html"><small><i>(obs)</i></small></a></li>
285
<li><a href="../c3ref/soft_heap_limit64.html">sqlite3_soft_heap_limit64</a></li>
286
<li><a href="../c3ref/libversion.html">sqlite3_sourceid</a></li>
287
<li><a href="../c3ref/sql.html">sqlite3_sql</a></li>
288
<li><a href="../c3ref/status.html">sqlite3_status</a></li>
289
<li><a href="../c3ref/step.html">sqlite3_step</a></li>
290
<li><a href="../c3ref/stmt_busy.html">sqlite3_stmt_busy</a></li>
291
<li><a href="../c3ref/stmt_readonly.html">sqlite3_stmt_readonly</a></li>
292
<li><a href="../c3ref/stmt_status.html">sqlite3_stmt_status</a></li>
293
<li><a href="../c3ref/stricmp.html">sqlite3_stricmp</a></li>
294
<li><a href="../c3ref/stricmp.html">sqlite3_strnicmp</a></li>
295
<li><a href="../c3ref/table_column_metadata.html">sqlite3_table_column_metadata</a></li>
296
<li><a href="../c3ref/test_control.html">sqlite3_test_control</a></li>
297
<li><a href="../c3ref/aggregate_count.html">sqlite3_thread_cleanup</a> <a href="../c3ref/experimental.html"><small><i>(obs)</i></small></a></li>
298
<li><a href="../c3ref/threadsafe.html">sqlite3_threadsafe</a></li>
299
<li><a href="../c3ref/total_changes.html">sqlite3_total_changes</a></li>
300
<li><a href="../c3ref/profile.html">sqlite3_trace</a></li>
301
<li><a href="../c3ref/aggregate_count.html">sqlite3_transfer_bindings</a> <a href="../c3ref/experimental.html"><small><i>(obs)</i></small></a></li>
302
<li><a href="../c3ref/unlock_notify.html">sqlite3_unlock_notify</a></li>
303
<li><a href="../c3ref/update_hook.html">sqlite3_update_hook</a></li>
304
<li><a href="../c3ref/uri_boolean.html">sqlite3_uri_boolean</a></li>
305
<li><a href="../c3ref/uri_boolean.html">sqlite3_uri_int64</a></li>
306
<li><a href="../c3ref/uri_boolean.html">sqlite3_uri_parameter</a></li>
307
<li><a href="../c3ref/user_data.html">sqlite3_user_data</a></li>
308
<li><a href="../c3ref/value_blob.html">sqlite3_value_blob</a></li>
309
<li><a href="../c3ref/value_blob.html">sqlite3_value_bytes</a></li>
310
<li><a href="../c3ref/value_blob.html">sqlite3_value_bytes16</a></li>
311
<li><a href="../c3ref/value_blob.html">sqlite3_value_double</a></li>
312
<li><a href="../c3ref/value_blob.html">sqlite3_value_int</a></li>
313
<li><a href="../c3ref/value_blob.html">sqlite3_value_int64</a></li>
314
<li><a href="../c3ref/value_blob.html">sqlite3_value_numeric_type</a></li>
315
<li><a href="../c3ref/value_blob.html">sqlite3_value_text</a></li>
316
<li><a href="../c3ref/value_blob.html">sqlite3_value_text16</a></li>
317
<li><a href="../c3ref/value_blob.html">sqlite3_value_text16be</a></li>
318
<li><a href="../c3ref/value_blob.html">sqlite3_value_text16le</a></li>
319
<li><a href="../c3ref/value_blob.html">sqlite3_value_type</a></li>
320
<li><a href="../c3ref/libversion.html">sqlite3_version,</a></li>
321
<li><a href="../c3ref/vfs_find.html">sqlite3_vfs_find</a></li>
322
<li><a href="../c3ref/vfs_find.html">sqlite3_vfs_register</a></li>
323
<li><a href="../c3ref/vfs_find.html">sqlite3_vfs_unregister</a></li>
324
<li><a href="../c3ref/mprintf.html">sqlite3_vmprintf</a></li>
325
<li><a href="../c3ref/mprintf.html">sqlite3_vsnprintf</a></li>
326
<li><a href="../c3ref/vtab_config.html">sqlite3_vtab_config</a></li>
327
<li><a href="../c3ref/vtab_on_conflict.html">sqlite3_vtab_on_conflict</a></li>
328
<li><a href="../c3ref/wal_autocheckpoint.html">sqlite3_wal_autocheckpoint</a></li>
329
<li><a href="../c3ref/wal_checkpoint.html">sqlite3_wal_checkpoint</a></li>
330
<li><a href="../c3ref/wal_checkpoint_v2.html">sqlite3_wal_checkpoint_v2</a></li>
331
<li><a href="../c3ref/wal_hook.html">sqlite3_wal_hook</a></li>
335
<a href="constlist.html">Constants</a> and
336
<a href="objlist.html">Objects</a>.</p>