|
Index[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] safe mode scalability of SQLite 2nd schemas returning information about 2nd viewing 2nd scripts benchmark.sh 2nd ppm.bat searching tables SQLite Database Browser security 2nd database locking 2nd 3rd 4th 5th file permissions 2nd multithreaded database access 2nd safe mode timeouts 2nd 3rd 4th 5th SELECT statement 2nd aggregate functions 2nd 3rd 4th 5th AND operator arithmetic operators 2nd 3rd BETWEEN operator callback functions 2nd 3rd column aliases 2nd FROM clause 2nd GROUP BY clause 2nd 3rd 4th HAVING clause 2nd IN operator IS NOT NULL operator IS NULL operator joins 2nd 3rd 4th 5th LEFT JOIN operator 2nd 3rd LIKE operator 2nd LIMIT clause 2nd NOT LIKE operator NULL values 2nd OR operator ORDER BY clause 2nd 3rd output, assigning to variables processing results of Tcl interface 2nd string comparisons 2nd 3rd string operators 2nd syntax 2nd 3rd 4th WHERE clause 2nd 3rd 4th 5th 6th sending output to files seq command SHARED locking state show_datatypes directive (PRAGMA command) SmallTalk sort order indexes source code, installing SQLite from 2nd special characters, escaping 2nd speed of SQLite 2nd SQL commands reading from files 2nd 3rd functions [See also specific function names] aggregating functions 2nd 3rd arbitrary data, referencing 2nd creating 2nd 3rd 4th 5th registering 2nd return values, setting 2nd UDFs (user-defined functions) 2nd 3rd 4th 5th aggregating functions 2nd 3rd 4th 5th binary data 2nd calling 2nd creating 2nd 3rd 4th SQL statements ALTER TABLE ANSI-92 unsupported features 2nd ATTACH DATABASE 2nd 3rd 4th 5th BEGIN TRANSACTION 2nd 3rd case sensitivity CHECK 2nd checking dbcmd complete command COLLATE comments COMMIT TRANSACTION 2nd 3rd COPY 2nd 3rd CREATE INDEX 2nd 3rd CREATE TABLE 2nd 3rd CHECK clause conflict resolution CONSTRAINT clause 2nd executing 2nd executing with C/C++ 2nd ON CONFLICT clause 2nd CREATE TABLE statement sample database 2nd 3rd 4th 5th CREATE TEMPORARY TABLE 2nd CREATE TRIGGER 2nd 3rd 4th CREATE UNIQUE INDEX 2nd 3rd 4th CREATE VIEW 2nd DEFAULT DELETE 2nd 3rd 4th DETACH DATABASE 2nd DISTINCT DROP INDEX DROP TABLE 2nd 3rd DROP TRIGGER 2nd DROP VIEW 2nd EXCEPT executing from files 2nd executing with callback functions 2nd 3rd sqlite_exec() function 2nd 3rd 4th executing with Perl DBI 2nd 3rd 4th executing with PySQLite 2nd 3rd 4th 5th 6th 7th executing with SQLite Database Browser executing with Tcl interface 2nd executing without callback functions 2nd 3rd 4th 5th 6th EXPLAIN 2nd 3rd 4th 5th FOREIGN KEY GRANT INSERT 2nd 3rd VALUES keyword 2nd INSERT INTO 2nd INSERT INTO statement sample database 2nd 3rd 4th 5th interrupting INTERSECT naming conventions 2nd normal keywords 2nd NOT NULL ON-CONFLICT 2nd OR 2nd PRAGMA 2nd PRIMARY KEY reserved keywords REVOKE RIGHT OUTER JOIN ROLLBACK TRANSACTION 2nd 3rd SELECT 2nd aggregate functions 2nd 3rd 4th 5th AND operator arithmetic operators 2nd 3rd BETWEEN operator callback functions 2nd 3rd column aliases 2nd FROM clause 2nd GROUP BY clause 2nd 3rd 4th HAVING clause 2nd IN operator IS NOT NULL operator IS NULL operator joins 2nd 3rd 4th 5th LEFT JOIN operator 2nd 3rd LIKE operator 2nd LIMIT clause 2nd NOT LIKE operator NULL values 2nd OR operator ORDER BY clause 2nd 3rd output, assigning to variables processing results of 2nd string comparisons 2nd 3rd string operators 2nd syntax 2nd 3rd 4th WHERE clause 2nd 3rd 4th 5th 6th SQL92 unsupported statements 2nd step-by-step execution system object names UNION UNION ALL UNIQUE UPDATE 2nd 3rd 4th 5th 6th VACUUM 2nd validating with Tcl interface 2nd 3rd SQL92 unsupported features 2nd SQLite downloading 2nd installation binary installation for Linux 2nd binary installation for Windows 2nd installing from source code 2nd RPM installation for Linux 2nd version, finding sqlite_version command SQLite Database Browser 2nd 3rd 4th sqlite dbcmd command SQLite mailing list sqlite tool 2nd 3rd 4th 5th 6th 7th 8th 9th 10th closing commands .databases 2nd .dump 2nd 3rd 4th .echo on|off .exit .explain on|off .header 2nd .headers .help 2nd .indices .mode .mode columns .mode html .mode insert .mode lines .mode list .nullvalue .output .prompt .quit .read 2nd 3rd 4th .schema 2nd .separator 2nd .show 2nd .tables .timeout .width 2nd obtaining list of database schemas returning information about 2nd database timeouts setting output sending to files output format, changing 2nd 3rd 4th 5th prompts changing SQL commands reading from files 2nd 3rd sqlite_master table 2nd 3rd SQLite version 3.0 2nd concurrency 2nd data typing 2nd 3rd file format changes 2nd naming conventions 2nd user-defined collating sequences 2nd SQLite, overview of 2nd customization 2nd help and support 2nd limitations 2nd portability 2nd scalability 2nd security 2nd speed 2nd when to avoid 2nd high concurrency 2nd high-volume websites 2nd network or client/server applications 2nd when to use ad-hoc file storage database-driven websites embedded devices internal data manipulation sqlite-2.8.15-1.i386.rpm package sqlite-2.8.15.bin.gz package sqlite-2.8.15.so.gz package sqlite-2.8.15.tar.gz package sqlite-2_8_15.zip file sqlite-devel package sqlite-devel-2.8.15-1.i386.rpm package sqlite.assoc_case directive (php.ini) sqlite.so.gz library sqlite3_open() function SQLITE_ABORT constant SQLITE_ABORT error code sqlite_aggregate_context() function sqlite_array_query() function 2nd 3rd 4th SQLITE_ASSOC constant SQLITE_AUTH constant SQLITE_AUTH error code SQLITE_BOTH constant SQLITE_BUSY constant SQLITE_BUSY error code SQLITE_BUSY Status 2nd sqlite_busy_handler() function 2nd 3rd sqlite_busy_handler[) function sqlite_busy_timeout() function sqlite_busy_timeout[) function SQLITE_CANTOPEN constant SQLITE_CANTOPEN error code sqlite_changes() function 2nd 3rd 4th 5th 6th 7th sqlite_changes[) function sqlite_close() function 2nd 3rd 4th 5th 6th sqlite_column() function 2nd sqlite_compile() function 2nd 3rd 4th 5th sqlite_complete() function 2nd sqlite_complete[) function SQLITE_CONSTRAINT constant SQLITE_CONSTRAINT error code SQLITE_CORRUPT constant SQLITE_CORRUPT error code sqlite_create_aggregate() function 2nd 3rd 4th 5th 6th sqlite_create_aggregate[) function sqlite_create_function() function 2nd 3rd 4th 5th 6th 7th 8th 9th sqlite_create_function[) function sqlite_current() function 2nd sqlite_decode_binary() function SQLITE_DONE constant SQLITE_DONE return code SQLITE_EMPTY constant SQLITE_EMPTY error code sqlite_encode_binary() function sqlite_encoding[) function 2nd SQLITE_ERROR constant SQLITE_ERROR error code sqlite_error_string() function 2nd 3rd sqlite_escape_string () function 2nd 3rd sqlite_exec() function 2nd 3rd 4th 5th 6th 7th sqlite_exec_printf() function sqlite_fetch_array() function 2nd 3rd sqlite_fetch_single() function 2nd 3rd sqlite_field_name() function 2nd sqlite_finalize() function 2nd 3rd 4th sqlite_freemem() function sqlite_freemem[) function SQLITE_FULL constant SQLITE_FULL error code sqlite_get_table() function 2nd 3rd sqlite_get_table[) function sqlite_get_table_mprintf[) function sqlite_has_more() function 2nd SQLITE_INERRUPT error code SQLITE_INTERNAL constant SQLITE_INTERNAL error code SQLITE_INTERRUPT constant sqlite_interrupt[) function SQLITE_IOERR constant SQLITE_IOERR error code sqlite_last_error() function 2nd 3rd sqlite_last_insert_rowid() function 2nd 3rd sqlite_last_insert_rowid[) function sqlite_libencoding() function 2nd sqlite_libversion() function 2nd SQLITE_LOCKED constant SQLITE_LOCKED error code sqlite_master table 2nd 3rd SQLITE_MISMATCH constant SQLITE_MISMATCH error code SQLITE_MISUSE constant SQLITE_MISUSE error code sqlite_mprintf() function sqlite_mprintf[) function sqlite_next() function 2nd 3rd SQLITE_NOLFS constant SQLITE_NOLFS error code SQLITE_NOMEM constant SQLITE_NOMEM error code SQLITE_NOTFOUND constant SQLITE_NOTFOUND error code SQLITE_NUM constant sqlite_num_fields() function 2nd sqlite_num_rows() function 2nd SQLITE_OK constant SQLITE_OK error code sqlite_open() function 2nd 3rd 4th 5th 6th 7th 8th 9th SQLITE_PERM constant SQLITE_PERM error code sqlite_popen() function 2nd 3rd 4th sqlite_progress_handler[) function SQLITE_PROTOCOL constant SQLITE_PROTOCOL error code sqlite_query() function 2nd 3rd 4th 5th SQLITE_READONLY constant SQLITE_READONLY error code sqlite_rewind() function 2nd SQLITE_ROW constant SQLITE_ROW return code SQLITE_SCHEMA constant SQLITE_SCHEMA error code sqlite_seek() function 2nd 3rd sqlite_set_result_double() function sqlite_set_result_double[) function sqlite_set_result_error[) function sqlite_set_result_int[) function sqlite_set_result_string[) function sqlite_step() function 2nd 3rd 4th 5th 6th SQLITE_TOOBIG constant SQLITE_TOOBIG error code sqlite_udf_decode_binary() function 2nd sqlite_udf_encode_binary() function 2nd sqlite_unbuffered_query() function 2nd sqlite_user_data[) function sqlite_version command sqlite_version[) function 2nd sqliteAtoF() function sqlitedll-2_8_15.zip file sqlitedll.zip library squite command StandardError class statements (SQL) ALTER TABLE ANSI-92 unsupported features 2nd ATTACH DATABASE 2nd 3rd 4th 5th BEGIN TRANSACTION 2nd 3rd case sensitivity CHECK 2nd checking COLLATE comments COMMIT TRANSACTION 2nd 3rd COPY 2nd 3rd CREATE INDEX 2nd 3rd CREATE TABLE 2nd 3rd CHECK clause conflict resolution CONSTRAINT clause 2nd executing 2nd executing with C/C++ 2nd ON CONFLICT clause 2nd sample database 2nd 3rd 4th 5th CREATE TEMPORARY TABLE 2nd CREATE TRIGGER 2nd 3rd 4th CREATE UNIQUE INDEX 2nd 3rd 4th CREATE VIEW 2nd DEFAULT DELETE 2nd 3rd 4th DETACH DATABASE 2nd DISTINCT DROP INDEX DROP TABLE 2nd 3rd DROP TRIGGER 2nd DROP VIEW 2nd EXCEPT executing from files 2nd executing with callback functions 2nd 3rd sqlite_exec() function 2nd 3rd 4th executing with Perl DBI 2nd 3rd 4th executing with PySQLite 2nd 3rd 4th 5th 6th 7th executing with SQLite Database Browser executing with Tcl interface 2nd executing without callback functions 2nd 3rd 4th 5th 6th EXPLAIN 2nd 3rd 4th 5th FOREIGN KEY GRANT INSERT 2nd 3rd VALUES keyword 2nd INSERT INTO 2nd sample database 2nd 3rd 4th 5th interrupting INTERSECT naming conventions 2nd normal keywords 2nd NOT NULL ON-CONFLICT 2nd OR 2nd PRAGMA 2nd PRIMARY KEY reserved keywords REVOKE RIGHT OUTER JOIN ROLLBACK TRANSACTION 2nd 3rd SELECT 2nd aggregate functions 2nd 3rd 4th 5th AND operator arithmetic operators 2nd 3rd BETWEEN operator callback functions 2nd 3rd column aliases 2nd FROM clause 2nd GROUP BY clause 2nd 3rd 4th HAVING clause 2nd IN operator IS NOT NULL operator IS NULL operator joins 2nd 3rd 4th 5th LEFT JOIN operator 2nd 3rd LIKE operator 2nd LIMIT clause 2nd NOT LIKE operator NULL values 2nd OR operator ORDER BY clause 2nd 3rd output, assigning to variables processing results of 2nd string comparisons 2nd 3rd string operators 2nd syntax 2nd 3rd 4th WHERE clause 2nd 3rd 4th 5th 6th SQL92 unsupported statements 2nd step-by-step executing system object names UNION UNION ALL UNIQUE UPDATE 2nd 3rd 4th 5th 6th VACUUM 2nd validating with Tcl interface 2nd 3rd step() function 2nd 3rd 4th strftime() function 2nd string map command string operators 2nd strings comparing 2nd 3rd operators 2nd special characters, escaping 2nd time string formats 2nd StrNe opcode su command substr() function sum() function sumFinalize() function sumStep() function suPHP support synchronous directive (PRAGMA command) 2nd system object names (SQL) |
|