requirements.html

这是sqlite3.56的文档。拿来给大家阅读使用

sqlite3_int64 sqlite3_last_insert_rowid(sqlite3*);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F12221</td><td valign="top">
The 
<a href="c3ref/last_insert_rowid.html">sqlite3_last_insert_rowid()</a> function returns the
rowid of the most recent successful insert done
on the same database connection and within the same
trigger context, or zero if there have
been no qualifying inserts on that connection.
</td></tr>
<tr><td valign="top">F12223</td><td valign="top">
The 
<a href="c3ref/last_insert_rowid.html">sqlite3_last_insert_rowid()</a> function returns
same value when called from the same trigger context
immediately before and after a ROLLBACK.
</td></tr>
<tr><td valign="top">F12240</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
int sqlite3_changes(sqlite3*);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F12241</td><td valign="top">
The 
<a href="c3ref/changes.html">sqlite3_changes()</a> function returns the number of
row changes caused by the most recent INSERT, UPDATE,
or DELETE statement on the same database connection and
within the same trigger context, or zero if there have
not been any qualifying row changes.
</td></tr>
<tr><td valign="top">F12260</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
int sqlite3_total_changes(sqlite3*);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F12261</td><td valign="top">
The 
<a href="c3ref/total_changes.html">sqlite3_total_changes()</a> returns the total number
of row changes caused by INSERT, UPDATE, and/or DELETE
statements on the same 
<a href="c3ref/sqlite3.html">database connection</a>, in any
trigger context, since the database connection was
created.
</td></tr>
<tr><td valign="top">F12270</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
void sqlite3_interrupt(sqlite3*);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F12271</td><td valign="top">
The 
<a href="c3ref/interrupt.html">sqlite3_interrupt()</a> interface will force all running
SQL statements associated with the same database connection
to halt after processing at most one additional row of
data.
</td></tr>
<tr><td valign="top">F12272</td><td valign="top">
Any SQL statement that is interrupted by 
<a href="c3ref/interrupt.html">sqlite3_interrupt()</a>
will return 
<a href="c3ref/c_abort.html">SQLITE_INTERRUPT</a>.
</td></tr>
<tr><td valign="top">F12280</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
void *sqlite3_trace(sqlite3*, void(*xTrace)(void*,const char*), void*);
void *sqlite3_profile(sqlite3*,
   void(*xProfile)(void*,const char*,sqlite3_uint64), void*);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F12281</td><td valign="top">
The callback function registered by 
<a href="c3ref/profile.html">sqlite3_trace()</a> is
whenever an SQL statement first begins to execute and
whenever a trigger subprogram first begins to run.
</td></tr>
<tr><td valign="top">F12282</td><td valign="top">
Each call to 
<a href="c3ref/profile.html">sqlite3_trace()</a> overrides the previously
registered trace callback.
</td></tr>
<tr><td valign="top">F12283</td><td valign="top">
A NULL trace callback disables tracing.
</td></tr>
<tr><td valign="top">F12284</td><td valign="top">
The first argument to the trace callback is a copy of
the pointer which was the 3rd argument to 
<a href="c3ref/profile.html">sqlite3_trace()</a>.
</td></tr>
<tr><td valign="top">F12285</td><td valign="top">
The second argument to the trace callback is a
zero-terminated UTF8 string containing the original text
of the SQL statement as it was passed into 
<a href="c3ref/prepare.html">sqlite3_prepare_v2()</a>
or the equivalent, or an SQL comment indicating the beginning
of a trigger subprogram.
</td></tr>
<tr><td valign="top">F12287</td><td valign="top">
The callback function registered by 
<a href="c3ref/profile.html">sqlite3_profile()</a> is invoked
as each SQL statement finishes.
</td></tr>
<tr><td valign="top">F12288</td><td valign="top">
The first parameter to the profile callback is a copy of
the 3rd parameter to 
<a href="c3ref/profile.html">sqlite3_profile()</a>.
</td></tr>
<tr><td valign="top">F12289</td><td valign="top">
The second parameter to the profile callback is a
zero-terminated UTF-8 string that contains the complete text of
the SQL statement as it was processed by 
<a href="c3ref/prepare.html">sqlite3_prepare_v2()</a>
or the equivalent.
</td></tr>
<tr><td valign="top">F12290</td><td valign="top">
The third parameter to the profile  callback is an estimate
of the number of nanoseconds of wall-clock time required to
run the SQL statement from start to finish.
</td></tr>
<tr><td valign="top">F12310</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
int sqlite3_busy_handler(sqlite3*, int(*)(void*,int), void*);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F12311</td><td valign="top">
The 
<a href="c3ref/busy_handler.html">sqlite3_busy_handler()</a> function replaces the busy handler
callback in the database connection identified by the 1st
parameter with a new busy handler identified by the 2nd and 3rd
parameters.
</td></tr>
<tr><td valign="top">F12312</td><td valign="top">
The default busy handler for new database connections is NULL.
</td></tr>
<tr><td valign="top">F12314</td><td valign="top">
When two or more database connection share a common cache,
the busy handler for the database connection currently using
the cache is invoked when the cache encounters a lock.
</td></tr>
<tr><td valign="top">F12316</td><td valign="top">
If a busy handler callback returns zero, then the SQLite
interface that provoked the locking event will return

<a href="c3ref/c_abort.html">SQLITE_BUSY</a>.
</td></tr>
<tr><td valign="top">F12318</td><td valign="top">
SQLite will invokes the busy handler with two argument which
are a copy of the pointer supplied by the 3rd parameter to

<a href="c3ref/busy_handler.html">sqlite3_busy_handler()</a> and a count of the number of prior
invocations of the busy handler for the same locking event.
</td></tr>
<tr><td valign="top">F12340</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
int sqlite3_busy_timeout(sqlite3*, int ms);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F12341</td><td valign="top">
The 
<a href="c3ref/busy_timeout.html">sqlite3_busy_timeout()</a> function overrides any prior

<a href="c3ref/busy_timeout.html">sqlite3_busy_timeout()</a> or 
<a href="c3ref/busy_handler.html">sqlite3_busy_handler()</a> setting
on the same database connection.
</td></tr>
<tr><td valign="top">F12343</td><td valign="top">
If the 2nd parameter to 
<a href="c3ref/busy_timeout.html">sqlite3_busy_timeout()</a> is less than
or equal to zero, then the busy handler is cleared so that
all subsequent locking events immediately return 
<a href="c3ref/c_abort.html">SQLITE_BUSY</a>.
</td></tr>
<tr><td valign="top">F12344</td><td valign="top">
If the 2nd parameter to 
<a href="c3ref/busy_timeout.html">sqlite3_busy_timeout()</a> is a positive
number N, then a busy handler is set that repeatedly calls
the xSleep() method in the VFS interface until either the
lock clears or until the cumulative sleep time reported back
by xSleep() exceeds N milliseconds.
</td></tr>
<tr><td valign="top">F12370</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
int sqlite3_get_table(
  sqlite3*,             /* An open database */
  const char *sql,      /* SQL to be evaluated */
  char ***pResult,      /* Results of the query */
  int *nrow,            /* Number of result rows written here */
  int *ncolumn,         /* Number of result columns written here */
  char **errmsg         /* Error msg written here */
);
void sqlite3_free_table(char **result);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F12371</td><td valign="top">
If a 
<a href="c3ref/free_table.html">sqlite3_get_table()</a> fails a memory allocation, then
it frees the result table under construction, aborts the
query in process, skips any subsequent queries, sets the
*resultp output pointer to NULL and returns 
<a href="c3ref/c_abort.html">SQLITE_NOMEM</a>.
</td></tr>
<tr><td valign="top">F12373</td><td valign="top">
If the ncolumn parameter to 
<a href="c3ref/free_table.html">sqlite3_get_table()</a> is not NULL
then 
<a href="c3ref/free_table.html">sqlite3_get_table()</a> write the number of columns in the
result set of the query into *ncolumn if the query is
successful (if the function returns SQLITE_OK).
</td></tr>
<tr><td valign="top">F12374</td><td valign="top">
If the nrow parameter to 
<a href="c3ref/free_table.html">sqlite3_get_table()</a> is not NULL
then 
<a href="c3ref/free_table.html">sqlite3_get_table()</a> write the number of rows in the
result set of the query into *nrow if the query is
successful (if the function returns SQLITE_OK).
</td></tr>
<tr><td valign="top">F12376</td><td valign="top">
The 
<a href="c3ref/free_table.html">sqlite3_get_table()</a> function sets its *ncolumn value
to the number of columns in the result set of the query in the
sql parameter, or to zero if the query in sql has an empty
result set.
</td></tr>
<tr><td valign="top">F12500</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
int sqlite3_set_authorizer(
  sqlite3*,
  int (*xAuth)(void*,int,const char*,const char*,const char*,const char*),
  void *pUserData
);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F12501</td><td valign="top">
The 
<a href="c3ref/set_authorizer.html">sqlite3_set_authorizer(D,...)</a> interface registers a
authorizer callback with database connection D.
</td></tr>
<tr><td valign="top">F12502</td><td valign="top">
The authorizer callback is invoked as SQL statements are
being compiled
</td></tr>
<tr><td valign="top">F12503</td><td valign="top">
If the authorizer callback returns any value other than

<a href="c3ref/c_deny.html">SQLITE_IGNORE</a>, 
<a href="c3ref/c_abort.html">SQLITE_OK</a>, or 
<a href="c3ref/c_deny.html">SQLITE_DENY</a> then
the 
<a href="c3ref/prepare.html">sqlite3_prepare_v2()</a> or equivalent call that caused
the authorizer callback to run shall fail with an

<a href="c3ref/c_abort.html">SQLITE_ERROR</a> error code and an appropriate error message.
</td></tr>
<tr><td valign="top">F12504</td><td valign="top">
When the authorizer callback returns 
<a href="c3ref/c_abort.html">SQLITE_OK</a>, the operation
described is coded normally.
</td></tr>
<tr><td valign="top">F12505</td><td valign="top">
When the authorizer callback returns 
<a href="c3ref/c_deny.html">SQLITE_DENY</a>, the

<a href="c3ref/prepare.html">sqlite3_prepare_v2()</a> or equivalent call that caused the
authorizer callback to run shall fail
with an 
<a href="c3ref/c_abort.html">SQLITE_ERROR</a> error code and an error message
explaining that access is denied.
</td></tr>
<tr><td valign="top">F12506</td><td valign="top">
If the authorizer code (the 2nd parameter to the authorizer
callback) is 
<a href="c3ref/c_alter_table.html">SQLITE_READ</a> and the authorizer callback returns

<a href="c3ref/c_deny.html">SQLITE_IGNORE</a> then the prepared statement is constructed to
insert a NULL value in place of the table column that would have
been read if 
<a href="c3ref/c_abort.html">SQLITE_OK</a> had been returned.
</td></tr>
<tr><td valign="top">F12507</td><td valign="top">
If the authorizer code (the 2nd parameter to the authorizer
callback) is anything other than 
<a href="c3ref/c_alter_table.html">SQLITE_READ</a>, then
a return of 
<a href="c3ref/c_deny.html">SQLITE_IGNORE</a> has the same effect as 
<a href="c3ref/c_deny.html">SQLITE_DENY</a>.
</td></tr>
<tr><td valign="top">F12510</td><td valign="top">
The first parameter to the authorizer callback is a copy of
the third parameter to the 
<a href="c3ref/set_authorizer.html">sqlite3_set_authorizer()</a> interface.
</td></tr>
<tr><td valign="top">F12511</td><td valign="top">
The second parameter to the callback is an integer

<a href="c3ref/c_alter_table.html">action code</a> that specifies the particular action
to be authorized.
</td></tr>
<tr><td valign="top">F12512</td><td valign="top">
The third through sixth parameters to the callback are
zero-terminated strings that contain
additional details about the action to be authorized.
</td></tr>
<tr><td valign="top">F12520</td><td valign="top">
Each call to 
<a href="c3ref/set_authorizer.html">sqlite3_set_authorizer()</a> overrides the
any previously installed authorizer.
</td></tr>
<tr><td valign="top">F12521</td><td valign="top">
A NULL authorizer means that no authorization
callback is invoked.
</td></tr>
<tr><td valign="top">F12522</td><td valign="top">
The default authorizer is NULL.
</td></tr>
<tr><td valign="top">F12550</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
/******************************************* 3rd ************ 4th ***********/
#define SQLITE_CREATE_INDEX          1   /* Index Name      Table Name      */
#define SQLITE_CREATE_TABLE          2   /* Table Name      NULL            */
#define SQLITE_CREATE_TEMP_INDEX     3   /* Index Name      Table Name      */
#define SQLITE_CREATE_TEMP_TABLE     4   /* Table Name      NULL            */