Small. Fast. Reliable.
Choose any three.

Search results 71..80 of 114 for: "x\"

C API: Checkpoint a database
(c3ref/wal_checkpoint_v2.html)
sqlite3_wal_checkpoint_v2()
The sqlite3_wal_checkpoint_v2(D,X,M,L,C) interface runs a checkpoint operation on database X of database connection D in mode M. Status information is written back into integers pointed to by L and C. The M parameter must be ... 
Database File Format
(fileformat.html)
4.2. Checksum Algorithm  ... In other words, if the inputs are x(0) through x(N) then N must be odd. The checksum algorithm is as follows: s0 = s1 = 0 for i from 0 to n-1 step 2: s0 += x(i) + s1; s1 ... 
C API: Create and Destroy VFS Filenames
(c3ref/create_filename.html)
sqlite3_create_filename(), sqlite3_free_filename()
 ... The memory obtained from sqlite3_create_filename(X) must be released by a corresponding call to sqlite3_free_filename(Y). The P parameter in sqlite3_create_filename(D,J,W,N,P) should be an array of 2*N pointers to strings. Each pair of pointers ... 
 ... CREATE TABLE t1(a); CREATE TABLE t2(x); SELECT * FROM (SELECT t1.a FROM t1 JOIN t2 ORDER BY t2.x LIMIT 1) ORDER BY 1; In version 3.5.9 the query above would return a single column named ... 
SQLite Foreign Key Support
(foreignkeys.html)
3. Required and Suggested Database Indexes  ... CREATE TABLE parent2(a, b, PRIMARY KEY(a,b)); CREATE TABLE child8(x, y, FOREIGN KEY(x,y) REFERENCES parent2); -- Ok CREATE TABLE child9(x REFERENCES parent2); -- Error! CREATE TABLE child10(x,y,z, FOREIGN KEY(x,y,z) REFERENCES ... 
3.1. The URI Path  ... On windows, if the absolute path begins with "/X:/" where X is any single ASCII alphabetic character ("a" through "z" or "A" through "Z") then the "X:" is understood to be the drive letter of the volume containing the file ... 
Deterministic SQL Functions
(deterministic.html)
1. Overview  ... For example, the abs(X) function always returns the same answer as long as its input X is the same. Non-deterministic functions might give different answers on each invocation, even if the arguments are always the same. The following ... 
C API: Unlock Notification
(c3ref/unlock_notify.html)
sqlite3_unlock_notify()
 ... For example, if connection X is waiting for connection Y's transaction to be concluded, and similarly connection Y is waiting on connection X's transaction, then neither connection will proceed and the system may remain deadlocked indefinitely. To avoid ... 
UPSERT
(lang_upsert.html)
 ... INSERT INTO t1 SELECT * FROM t2 ON CONFLICT(x) DO UPDATE SET y=excluded.y; Ambiguity resolved using a WHERE clause: INSERT INTO t1 SELECT * FROM t2 WHERE true ON CONFLICT(x) DO UPDATE SET y=excluded.y; 3. Limitations ... 
7.4. The "merge=X,Y" command The "merge=X,Y" command (where X and Y are integers) causes SQLite to do a limited amount of work toward merging the various inverted index b-trees of an FTS3/4 table together into one large b-tree. The ... 

12345678910

Page generated by FTS5 in about 89.17 ms.