sqlite3_last_insert_rowid()

 ... This function is accessible to SQL statements via the last_insert_rowid() SQL function. If a separate thread performs a new INSERT on the same database connection while the sqlite3_last_insert_rowid() function is running and thus changes the last insert rowid, then the ... 

sqlite3_set_last_insert_rowid()

The sqlite3_set_last_insert_rowid(D, R) method allows the application to set the value returned by calling sqlite3_last_insert_rowid(D) to R without inserting a row into the database. See also lists of Objects, Constants, and Functions.

struct sqlite3

 ... sqlite3_db_release_memory sqlite3_db_status sqlite3_drop_modules sqlite3_enable_load_extension sqlite3_errcode sqlite3_errmsg sqlite3_errmsg16 sqlite3_error_offset sqlite3_errstr sqlite3_exec sqlite3_extended_errcode sqlite3_extended_result_codes sqlite3_file_control sqlite3_free_table sqlite3_get_autocommit sqlite3_get_clientdata sqlite3_get_table sqlite3_interrupt sqlite3_is_interrupted sqlite3_last_insert_rowid sqlite3_limit sqlite3_load_extension sqlite3_next_stmt sqlite3_overload_function sqlite3_prepare sqlite3_prepare16 sqlite3_prepare16_v2 sqlite3_prepare16_v3 sqlite3_prepare_v2 sqlite3_prepare_v3 sqlite3_preupdate_blobwrite sqlite3_preupdate_count sqlite3_preupdate_depth sqlite3_preupdate_hook sqlite3_preupdate_new sqlite3_preupdate_old sqlite3_profile sqlite3_progress_handler sqlite3_rollback_hook sqlite3_set_authorizer ... 

1. Overview  ... random() changes() last_insert_rowid() sqlite3_version() The random() function is obviously non-deterministic because it gives a different answer every time it is invoked. The answers from changes() and last_insert_rowid() depend on prior SQL statements, and so they are also non-deterministic ... 

2. Differences From Ordinary Rowid Tables  ... The sqlite3_last_insert_rowid() function does not work for WITHOUT ROWID tables. Inserts into a WITHOUT ROWID do not change the value returned by the sqlite3_last_insert_rowid() function. The last_insert_rowid() SQL function is also unaffected since it is just a wrapper around sqlite3_last_insert_rowid ... 

 ... last_insert_rowid() The last_insert_rowid() function returns the ROWID of the last row insert from the database connection which invoked the function. The last_insert_rowid() SQL function is a wrapper around the sqlite3_last_insert_rowid() C/C++ interface function. length(X) For a string value ... 

 ... You can retrieve this integer using the sqlite_last_insert_rowid() API function or using the last_insert_rowid() SQL function in a subsequent SELECT statement. 3.0   Comparison and Sort Order SQLite is typeless for the purpose of deciding what data is allowed ... 

 ... if {[db exists {SELECT 1 FROM table1 WHERE user=$user}]} {    # Processing if $user exists } else {    # Processing if $user does not exist } The "last_insert_rowid" method The "last_insert_rowid" method returns an integer which is ... 

 ... int sqlite_last_insert_rowid(sqlite*); int sqlite_changes(sqlite*); int sqlite_get_table( sqlite*, char *sql, char ***result, int *nrow, int *ncolumn, char **errmsg ); void sqlite_free_table(char**); void sqlite_interrupt(sqlite*); int sqlite_complete(const char *sql); void sqlite_busy_handler(sqlite*, int (*)(void*,const char*,int), void*); void ... 

 ... INSERT INTO t1 VALUES((SELECT max(a) FROM t1)+1,123); There is a function named sqlite3_last_insert_rowid() which will return the integer key for the most recent insert operation. Note that the integer key is one greater than the largest ...