SQLite
|
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] P1 opcode packages coreutils sqlite-2.8.15-1.i386.rpm sqlite-2.8.15.bin.gz sqlite-2.8.15.so.gz sqlite-2.8.15.tar.gz sqlite-2_8_15.zip sqlite-devel sqlite-devel-2.8.15-1.i386.rpm sqlitedll-2_8_15.zip tclsqlite-2.8.15.so.gz tclsqlite-2_8_15.zip tclsqlite.so.gz tclsqlite.zip pagers parameters database parameters changing for current session 2nd 3rd changing permanently 2nd query parameters editing 2nd 3rd 4th parser_trace directive (PRAGMA command) parsers PEAR class 2nd 3rd pear tool 2nd PENDING locking state performance optimization EXPLAIN statement 2nd 3rd 4th 5th indexes 2nd benchmarking 2nd 3rd benefits of 2nd 3rd 4th creating 2nd 3rd 4th dropping 2nd examples 2nd 3rd 4th 5th 6th 7th multiple columns 2nd table lists 2nd unique indexes 2nd 3rd 4th when to create 2nd when to use 2nd 3rd PRAGMA statement 2nd transactions 2nd VACUUM statement 2ndPerl DBI aggregating creating 2nd 3rd 4th 5th 6th user-defined functions, creating 2nd 3rd 4th 5th 6th Perl DBI (Database Interface) 2nd 3rd available drivers 2nd bind values 2nd 3rd 4th 5th 6th 7th 8th 9th data safety databases adding tables to 2nd closing 2nd deleting records from 2nd 3rd fetching records from 2nd 3rd 4th 5th opening 2nd 3rd 4th 5th 6th 7th updating 2nd 3rd error reporting 2nd 3rd 4th functions available_drivers() 2nd begin_work() 2nd bind_param() 2nd 3rd commit() 2nd connect() 2nd 3rd 4th 5th 6th 7th create_aggregate() 2nd 3rd 4th 5th create_function() 2nd 3rd 4th die() 2nd disconnect() 2nd do() err() errstr() execute() 2nd 3rd 4th 5th 6th 7th fetchall_arrayref() 2nd 3rd fetchall_hashref() 2nd fetchrow_array() 2nd 3rd 4th fetchrow_arrayref() 2nd fetchrow_hash() fetchrow_hashref() finalize() 2nd 3rd finish() 2nd func() installed_versions() last_insert_rowid() new() 2nd 3rd prepare() 2nd 3rd 4th quote() 2nd 3rd 4th rollback() 2nd rows() step() 2nd 3rd trace() 2nd 3rd 4th 5th warn() 2nd installing 2nd 3rd loading 2nd modules queries fetching rows from 2nd 3rd 4th 5th 6th returning information about 2nd SQL statements, executing 2nd 3rd 4th tracing 2nd 3rd 4th transactions 2nd 3rd 4th version, finding permissions file permissions 2nd persistent connections PHP 2nd configuring for Linux/Unix 2nd configuring for Windows 2nd constants 2nd databases closing 2nd confirming changes to 2nd 3rd opening 2nd 3rd 4th 5th persistent connections documentation 2nd error reporting 2nd 3rd functions addslashes() date() datetime() dl() extension_loaded() getAll() getRow() isError() jullianday() last_insert_rowid() length() lower() median() 2nd 3rd 4th php() 2nd phpinfo() query() sqlite_array_query() 2nd 3rd 4th sqlite_busy_timeout() sqlite_changes() 2nd 3rd 4th sqlite_close() 2nd sqlite_column() 2nd sqlite_create_aggregate() 2nd 3rd 4th 5th sqlite_create_function() 2nd 3rd 4th 5th 6th sqlite_current() 2nd sqlite_decode_binary() sqlite_encode_binary() sqlite_error_string() 2nd 3rd sqlite_escape_string() 2nd 3rd sqlite_fetch_array() 2nd 3rd sqlite_fetch_single() 2nd 3rd sqlite_field_name() 2nd sqlite_has_more() 2nd sqlite_last_error() 2nd 3rd sqlite_last_insert_rowid() 2nd sqlite_libencoding() 2nd sqlite_libversion() 2nd sqlite_next() 2nd 3rd sqlite_num_fields() 2nd sqlite_num_rows() 2nd sqlite_open() 2nd 3rd 4th sqlite_popen() 2nd 3rd 4th sqlite_query() 2nd 3rd 4th 5th sqlite_rewind() 2nd sqlite_seek() 2nd 3rd sqlite_udf_decode_binary() 2nd sqlite_udf_encode_binary() 2nd sqlite_unbuffered_query() 2nd strftime() 2nd substr() time() ucwords() upper() word_reverse() 2nd PEAR database class 2nd 3rd queries executing 2nd 3rd 4th 5th returning information about 2nd 3rd 4th result sets accessing random rows 2nd displaying in HTML tables 2nd 3rd 4th 5th processing 2nd 3rd 4th 5th 6th 7th 8th returning in single array 2nd 3rd runtime configuration 2nd safe mode special characters, escaping 2nd SQLite extension, returning information about 2nd SQLite support, checking for 2nd suPHP PHP interface 2nd php() function 2nd php.ini directives sqlite.assoc_case phpinfo() function portability of SQLite 2nd ppm.bat script PRAGMA command database analysis 2nd 3rd database information, returning 2nd 3rd 4th database parameters changing for current session 2nd 3rd changing permanently 2nd directives cache_size count_changes 2nd database_list default 2nd full_column_names index_info 2nd index_list 2nd integrity_check parser_trace show_datatypes synchronous 2nd table_info temp_store vdbe_trace 2nd query parameters editing 2nd 3rd 4th PRAGMA statement 2nd prepare() function 2nd 3rd 4th PRIMARY KEY columns PRIMARY KEY statement PrintError exception printf() (_printf()) wrapper functions 2nd ProgrammingError class prompts changing PySQLite 2nd 3rd aggregating functions creating 2nd 3rd 4th 5th commands cu.execute() 2nd 3rd 4th 5th cu.fetchall() 2nd cu.fetchmany() 2nd 3rd 4th cu.fetchone() 2nd 3rd cu.rowcount() 2nd 3rd cu.rownumber() cx = sqlite.connect() 2nd 3rd 4th 5th cx.close() 2nd cx.commit() 2nd cx.create_aggregate() 2nd 3rd 4th 5th 6th cx.create_function() 2nd 3rd cx.cursor() 2nd cx.rollback() compiling connection parameters 2nd data type mappings 2nd 3rd 4th 5th databases checking updates to 2nd 3rd closing 2nd 3rd 4th 5th fetching records from 2nd 3rd 4th 5th inserting records into 2nd 3rd 4th 5th 6th opening 2nd 3rd 4th 5th downloading error handling 2nd 3rd 4th 5th 6th installing 2nd preparing to use SQL statements executing 2nd 3rd 4th 5th modifying query values 2nd transactions 2nd user-defined functions creating 2nd 3rd 4th 5th 6th 7thPython interface [See PySQLite] [See PySQLite] |
|