Small. Fast. Reliable.
Choose any three.

Search results 31..40 of 103 for: "x\"

ALTER TABLE
(lang_altertable.html)
 ... Transfer content from X into new_X using a statement like: INSERT INTO new_X SELECT ... FROM X. Drop the old table X: DROP TABLE X. Change the name of new_X to X using: ALTER TABLE new_X RENAME TO X. Use CREATE ... 
Partial Indexes
(partialindex.html)
3. Queries Using Partial Indexes Let X be the expression in the WHERE clause of a partial index, and let W be the WHERE clause of a query that uses the table that is indexed. Then, the query is permitted to use the partial index ... 
sqlite3_str_new()
 ... To avoid memory leaks, the object returned by sqlite3_str_new() must be freed by a subsequent call to sqlite3_str_finish(X). The sqlite3_str_new(D) interface always returns a pointer to a valid sqlite3_str object, though in the event of an out-of ... 
Database Object Name Resolution
(lang_naming.html)
 ... For example: /* Add a table named 't1' to the temp, main and an attached database */ ATTACH 'file.db' AS aux; CREATE TABLE t1(x, y); CREATE TEMP TABLE t1(x, y); CREATE TABLE aux.t1(x, y); DROP TABLE t1 ... 
sqlite3_vtab_nochange()
If the sqlite3_vtab_nochange(X) routine is called within the xColumn method of a virtual table, then it might return true if the column is being fetched as part of an UPDATE operation during which the column value will not change ... 
3.8. The geopoly_contains_point(P,X,Y) Function If P is a polygon, then geopoly_contains_point(P,X,Y) returns a non-zero integer if and only if the coordinate X,Y is inside or on the boundary of the polygon P. If P is not a polygon, geopoly_contains_point ... 
C API: Extract Metadata About A Column Of A Table
(c3ref/table_column_metadata.html)
sqlite3_table_column_metadata()
The sqlite3_table_column_metadata(X,D,T,C,....) routine returns information about column C of table T in database D on database connection X. The sqlite3_table_column_metadata() interface returns SQLITE_OK and fills in the non-NULL pointers in the final five arguments with ... 
sqlite3_auto_extension(), struct sqlite3_api_routines
 ... Calling sqlite3_auto_extension(X) with an entry point X that is already on the list of automatic extensions is a harmless no-op. No entry point will be called more than once for each database connection that is opened. See also ... 
8.2. Range Queries  ... CREATE TABLE ex2(x,y,z); CREATE INDEX ex2i1 ON ex2(x); CREATE INDEX ex2i2 ON ex2(y); SELECT z FROM ex2 WHERE x BETWEEN 1 AND 100 AND y BETWEEN 1 AND 100; Further suppose that column x contains ... 
NUL Characters In Strings
(nulinstr.html)
3. How To Tell If You Have NUL Characters In Your Strings  ... 1,X'6162630078797a' In the BLOB output, you can clearly see the NUL character as the 4th character in the 7-character string. Another, more automated, way to tell if a string value X contains embedded NUL characters is to ... 

12345678910

Page generated by FTS5 in about 132.09 ms.