Small. Fast. Reliable.
Choose any three.

Search results 41..50 of 103 for: "x\"

CREATE TABLE
(lang_createtable.html)
 ... CREATE TABLE t(x INTEGER PRIMARY KEY ASC, y, z); CREATE TABLE t(x INTEGER, y, z, PRIMARY KEY(x ASC)); CREATE TABLE t(x INTEGER, y, z, PRIMARY KEY(x DESC)); But the following declaration does not result in ... 
SQL Language Expressions
(lang_expr.html)
 ... The BETWEEN operator The BETWEEN operator is logically equivalent to a pair of comparisons. "x BETWEEN y AND z" is equivalent to "x>=y AND x<=z" except that with BETWEEN, the x expression is only evaluated once ... 
Window Functions
(windowfunctions.html)
1. Introduction to Window Functions  ... CREATE TABLE t0(x INTEGER PRIMARY KEY, y TEXT); INSERT INTO t0 VALUES (1, 'aaa'), (2, 'ccc'), (3, 'bbb'); -- The following SELECT statement returns: -- -- x | y | row_number ----------------------- -- 1 | aaa | 1 -- 2 | ccc | 3 -- 3 | bbb | 2 -- SELECT x, y, row_number ... 
sqlite3_stmt_readonly()
The sqlite3_stmt_readonly(X) interface returns true (non-zero) if and only if the prepared statement X makes no direct changes to the content of the database file. Note that application-defined SQL functions or virtual tables might change the database ... 
SQLite In 5 Minutes Or Less
(quickstart.html)
 ... 01 #!/usr/bin/tclsh 02 if {$argc!=2} { 03 puts stderr "Usage: %s DATABASE SQL-STATEMENT" 04 exit 1 05 } 06 package require sqlite3 07 sqlite3 db [lindex $argv 0] 08 db eval [lindex $argv 1] x { 09 ... 
SQLite Archive Files
(sqlar.html)
5. Managing SQLite Archives From Application Code  ... sqlar_compress(X) The sqlar_compress(X) function attempts to compress a copy of the string or blob X using the Default algorithm and returns the result as a blob. If the input X is incompressible, then a copy of X is ... 
The Spellfix1 Virtual Table
(spellfix1.html)
7. Auxiliary Functions  ... spellfix1_phonehash(X) This routine constructs a phonetic hash of the pure ascii input word X and returns that hash. This routine is used internally by spellfix1 in order to transform the K1 column of the shadow table into the K2 ... 
2.1. Substitution Types  ... x, X The argument is an integer which is displayed in hexadecimal. Lower-case hexadecimal is used for %x and upper-case is used for %X o The argument is an integer which is displayed in octal. s, z The ... 
 ... Apple uses SQLite in many (most?) of the native applications running on Mac OS-X desktops and servers and on iOS devices such as iPhones and iPods. SQLite is also used in iTunes, even on non-Apple hardware. Bentley Systems ... 
sqlite3_busy_handler()
The sqlite3_busy_handler(D,X,P) routine sets a callback function X that might be invoked with argument P whenever an attempt is made to access a database table associated with database connection D when another thread or process has the ... 

12345678910

Page generated by FTS5 in about 132.39 ms.