|
|
 |
| Авторизация |
|
|
|
| Поиск по указателям |
|
|
|
|
|
|
|
 |
|
|
|
| Newman Ch. — SQLite |
|
|
|
| Предметный указатель |
code listings, records, inserting with Tcl
code listings, result sets
code listings, result sets, accessing random rows in 2nd
code listings, result sets, displaying in HTML tables 2nd
code listings, result sets, displaying with callback functions 2nd
code listings, result sets, returning in single array 2nd
code listings, result sets, returning one at a time 2nd
code listings, rows
code listings, rows, inserting with Tcl
code listings, SELECT queries
code listings, SELECT queries, assigning output to variables
code listings, SELECT queries, processing results of 2nd
code listings, special characters, escaping 2nd
code listings, SQL statements
code listings, SQL statements, CREATE TABLE
code listings, SQL statements, executing with Tcl
code listings, SQL statements, validating with Tcl interface 2nd
code listings, SQLite extension, checking for
code listings, SQLITE_BUSY Status 2nd
code listings, sqlite_busy_handler() function 2nd
code listings, tables
code listings, tables, creating with ANSI data types
code listings, tables, creating with made-up data types
code listings, tables, creating without data types
code listings, UDFs (user-defined functions)
code listings, UDFs (user-defined functions), aggregating functions 2nd
code listings, UDFs (user-defined functions), calling with php() 2nd
code listings, UDFs (user-defined functions), creating 2nd
code listings, user-defined functions
code listings, user-defined functions, registering with Tcl interface 2nd
code listings, vegetables.csv
code listings, virtual machine program 2nd
COLLATE statement
collating sequences
collating sequences, SQLite version 3.0 2nd
Column opcode
Columns
columns, aliases 2nd
columns, binary data 2nd
columns, BLOBs 2nd
columns, constraints 2nd
columns, dates 2nd
columns, DEFAULT
columns, defining 2nd
columns, INTEGER PRIMARY KEY columns 2nd
columns, multiple columns
columns, multiple columns, indexing 2nd
columns, NOT NULL 2nd
columns, PRIMARY KEY
columns, returning information about 2nd
columns, UNIQUE
Commands [See names of specific commands] [See names of specific commands] [See statements]
command_logfile argument (sqlite.connect() command)
Comments
COMMIT TRANSACTION statement 2nd 3rd
commit() function 2nd
commit() method
committing
committing, transactions
committing, transactions, commit() function 2nd
comparing strings 2nd 3rd
compiling
compiling, PySQLite
Complete method 2nd
Concatenation operator
Concurrency
concurrency, high concurrency 2nd
concurrency, SQLite version 3.0 2nd
Configuration
Configuration, PHP 2nd
configuration, PHP, Linux/Unix configuration 2nd
configuration, PHP, SQLite extension, returning information about 2nd
configuration, PHP, SQLite support, checking for 2nd
configuration, PHP, Windows configuration 2nd
configure command
confirming
confirming, database changes 2nd 3rd
conflict resolution 2nd 3rd 4th
connect() function 2nd 3rd 4th 5th 6th 7th
connecting to databases 2nd
connection parameters
connection parameters, PySQLite 2nd
Constants
constants, SQLITE_ASSOC
constants, SQLITE_BOTH
constants, SQLITE_NUM
CONSTRAINT clause
CONSTRAINT clause, CREATE TABLE statement 2nd
constraints (column) 2nd
convenience functions 2nd 3rd
converters argument (sqlite.connect() command)
Converting
converting, time zones
Coordinated Universal Time (UTC)
COPY statement 2nd 3rd
copying
copying, tables
core C API
coreutils package
count() function 2nd 3rd
count_changes directive (PRAGMA command) 2nd
CREATE INDEX statement 2nd 3rd
CREATE TABLE statement
CREATE TABLE statement, executing 2nd
CREATE TABLE statement, executing with C/C++ 2nd
CREATE TABLE statement, sample database 2nd 3rd 4th 5th
CREATE TRIGGER statement 2nd 3rd 4th
CREATE UNIQUE INDEX statement 2nd 3rd 4th
CREATE VIEW statement 2nd
create_aggregate() function 2nd 3rd 4th 5th
create_function() function 2nd 3rd 4th
cu.execute() command 2nd 3rd 4th 5th
cu.fetchall() command 2nd
cu.fetchmany() command 2nd 3rd 4th
cu.fetchone() command 2nd 3rd
cu.rowcount() command 2nd 3rd
cu.rownumber() command
custom functions
custom functions, registering
custom functions, registering, dbcmd function command
Customization 2nd 3rd
cx = sqlite.connect() command 2nd 3rd 4th 5th
cx.close() command 2nd
cx.commit() command 2nd
cx.create_aggregate() command 2nd 3rd 4th 5th 6th
cx.create_function() command 2nd 3rd
cx.cursor() command 2nd
cx.rollback() command
data safety
data safety, Perl DBI
Data Source Name (DSN)
Data types 2nd 3rd
data types, manifest typing
data types, mapping
data types, mapping, PySQLite 2nd 3rd 4th 5th
data types, SQLite version 3.0 2nd 3rd
Database Browser 2nd 3rd 4th
database-driven websites
DatabaseError class 2nd
databases 2nd 3rd 4th 5th
databases, adding data to 2nd 3rd 4th 5th 6th
databases, adding data to SELECT query results 2nd
databases, adding data to single rows 2nd
databases, analyzing 2nd 3rd
databases, attaching to 2nd 3rd 4th 5th 6th 7th 8th
databases, backing up 2nd
databases, backing up, .dump command 2nd 3rd
databases, checking changes to Tcl interface 2nd
databases, checking updates to PySQLite interface 2nd 3rd
databases, closing
| databases, closing, cx.close() command 2nd
databases, closing, dbcmd close command
databases, closing, disconnect() function 2nd
databases, closing, sqlite_close() function 2nd 3rd 4th 5th
databases, closing, Tcl interface 2nd
databases, columns
databases, columns, aliases 2nd
databases, columns, constraints 2nd
databases, columns, DEFAULT
databases, columns, defining 2nd
databases, columns, NOT NULL 2nd
databases, columns, PRIMARY KEY
databases, columns, UNIQUE
databases, confirming changes to 2nd 3rd
databases, conflict resolution 2nd
databases, connecting to 2nd
databases, creating 2nd
databases, dates/times 2nd
databases, dates/times, date() function
databases, dates/times, date/time conversion specifiers
databases, dates/times, datetime() function
databases, dates/times, displaying 2nd
databases, dates/times, jullianday() function
databases, dates/times, modifiers 2nd 3rd
databases, dates/times, strftime() function 2nd
databases, dates/times, time string formats 2nd
databases, dates/times, time zones 2nd
databases, dates/times, time() function
databases, deleting records from
databases, deleting records from, Perl DBI 2nd 3rd
databases, detaching
databases, detaching from
databases, fetching records from
databases, fetching records from, Perl DBI 2nd 3rd 4th 5th
databases, fetching records from, PySQLite interface 2nd 3rd 4th 5th
databases, file permissions 2nd
databases, finding information about database changes
databases, indexes 2nd
databases, indexes, benchmarking 2nd 3rd
databases, indexes, benefits of 2nd 3rd 4th
databases, indexes, creating 2nd 3rd 4th
databases, indexes, dropping 2nd
databases, indexes, examples 2nd 3rd 4th 5th 6th
databases, indexes, multiple columns 2nd
databases, indexes, sort order
databases, indexes, table lists 2nd
databases, indexes, unique indexes 2nd 3rd 4th
databases, indexes, when to create 2nd
databases, indexes, when to use 2nd 3rd
databases, inserting data into
databases, inserting data into, C/C++ interface 2nd 3rd 4th
databases, inserting records into
databases, inserting records into, PySQLite interface 2nd 3rd 4th 5th 6th
databases, joins 2nd 3rd 4th 5th
databases, joins, Cartesian joins 2nd
databases, joins, left joins 2nd 3rd
databases, locked databases
databases, locked databases, handling with Tcl interface 2nd
databases, locked files 2nd 3rd 4th
databases, locking 2nd 3rd 4th 5th
databases, locking, SQLite version 3.0
databases, multithreaded database access 2nd
databases, nested subqueries 2nd
databases, opening
databases, opening, connect() function 2nd 3rd 4th 5th 6th 7th
databases, opening, cx = sqlite.connect() command 2nd 3rd 4th 5th
databases, opening, PEAR database class 2nd 3rd
databases, opening, sqlite dbcmd command
databases, opening, sqlite_open() function 2nd 3rd 4th 5th 6th 7th 8th 9th
databases, opening, Tcl interface 2nd
databases, parameters
databases, parameters, changing for current session 2nd 3rd
databases, parameters, changing permanently 2nd
databases, persistent connections
databases, query parameters
databases, query parameters, editing 2nd 3rd 4th
databases, querying with SELECT statement
databases, querying with SELECT statement, aggregate functions 2nd 3rd 4th 5th
databases, querying with SELECT statement, AND operator
databases, querying with SELECT statement, arithmetic operators 2nd 3rd
databases, querying with SELECT statement, BETWEEN operator
databases, querying with SELECT statement, callback functions 2nd 3rd
databases, querying with SELECT statement, column aliases 2nd
databases, querying with SELECT statement, FROM clause 2nd
databases, querying with SELECT statement, GROUP BY clause 2nd 3rd 4th
databases, querying with SELECT statement, HAVING clause 2nd
databases, querying with SELECT statement, IN operator
databases, querying with SELECT statement, IS NOT NULL operator
databases, querying with SELECT statement, IS NULL operator
databases, querying with SELECT statement, joins 2nd 3rd 4th 5th
databases, querying with SELECT statement, LEFT JOIN operator 2nd 3rd
databases, querying with SELECT statement, LIKE operator 2nd
databases, querying with SELECT statement, LIMIT clause 2nd
databases, querying with SELECT statement, NOT LIKE operator
databases, querying with SELECT statement, NULL values 2nd
databases, querying with SELECT statement, OR operator
databases, querying with SELECT statement, ORDER BY clause 2nd 3rd
databases, querying with SELECT statement, string comparisons 2nd 3rd
databases, querying with SELECT statement, string operators 2nd
databases, querying with SELECT statement, syntax 2nd 3rd 4th
databases, querying with SELECT statement, WHERE clause 2nd 3rd 4th 5th 6th
databases, records
databases, records, adding with Tcl interface 2nd 3rd 4th 5th
databases, records, deleting 2nd 3rd 4th
databases, records, fetching with Tcl interface 2nd 3rd
databases, records, updating 2nd 3rd 4th
databases, returning information about 2nd 3rd 4th
databases, rows
databases, rows, inserting with Tcl interface 2nd
databases, schemas
databases, schemas, returning information about 2nd
databases, SQLite Database Browser 2nd 3rd 4th
databases, table schemas, viewing 2nd
databases, tables
databases, tables, adding
databases, tables, altering 2nd
databases, tables, binary data 2nd
databases, tables, BLOBs 2nd
databases, tables, browsing
databases, tables, conflict resolution 2nd
databases, tables, copying
databases, tables, creating 2nd
databases, tables, creating with Perl DBI 2nd
databases, tables, data types 2nd 3rd
databases, tables, dates 2nd
databases, tables, dropping 2nd 3rd
databases, tables, full table scan
databases, tables, INTEGER PRIMARY KEY columns 2nd
databases, tables, searching
databases, tables, sqlite_master 2nd 3rd
databases, tables, temporary tables 2nd
databases, time-tracking sample database
databases, time-tracking sample database, adding data to 2nd 3rd 4th 5th
databases, time-tracking sample database, binary data 2nd
databases, time-tracking sample database, BLOBs 2nd
databases, time-tracking sample database, data types 2nd 3rd
databases, time-tracking sample database, dates 2nd
databases, time-tracking sample database, INTEGER PRIMARY KEY columns 2nd
databases, time-tracking sample database, tables 2nd 3rd
databases, timeouts 2nd 3rd 4th 5th
databases, timeouts, setting
databases, timeouts, Tcl interface 2nd
databases, transactions 2nd 3rd 4th 5th 6th 7th 8th 9th
databases, transactions, nesting
databases, transactions, PySQLite interface 2nd
databases, triggers
databases, triggers, creating 2nd 3rd 4th
databases, triggers, defined
databases, triggers, dropping 2nd 3rd
databases, triggers, example 2nd
|
|
|
| Реклама |
|
|
|
|
|
|
|
|
О проекте