Index: D

Book Home

Symbols & Numbers | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

Index: D

data

caching, in applications: 5.2.1. Host Application Tuning
deleting: 3.6.5. Deletes
encrypting: 6.2.3.2. Encryption
managing: 3.6. Managing Data
pulling from MySQL: 3.9.7.3. Pulling data from MySQL
writing with PHP: 11.6. Writing Data with PHP

data directories, setting permissions on: 6.2.1. Operating System Security

data models: 7.1.3. Data Model

methodology for: 7.3. A Logical Data-Modeling Methodology

data source connectivity with JDBC API: 13.1.2.1. Data source connectivity

13.1.3.2. Data sources revisited

data types

MySQL: 16. MySQL Data Types
MySQL C API: 19.1. Data Types
Python: 10.1.3. Parameterized SQL
SQL: 3.4. MySQL Data Types

database administrator (DBA) role in MySQL installations: 6.1.1. User Management

DataBase Driver (DBD) module: 9. Perl

database entities (see entities)

DATABASE( ) function: 3.7. Queries

17.2.2. General Functions

database handles: 9.1.1. Basic Perl Example

closing: 9.1.1. Basic Perl Example
controlling attributes of, using connect( ): 9.1.3. Error Handling and Attributes
returning, using getDB( ): 9.3.2.7. The DB class

DataBase Interface module ) (see DBI module (Perl)

database management system (DBMS): 1.1. Relational Databases

database servers

closing connections to: 19.2. Functions

creating connections to: 19.2. Functions

19.2. Functions

dumping debug information: 19.2. Functions

getting host information: 19.2. Functions

operating status of: 19.2. Functions

performance tuning for: 5.3. Database Server Tuning

reloading permission tables on: 19.2. Functions

shutting down: 19.2. Functions

Database SIG (Special Interest Group): 10.1. DB-API

databases

accessing with JDBC: 13.2. Simple Database Access

administration tasks: 4. Database Administration

applications (see applications)

checking integrity: 4.6. Table Maintenance and Crash Recovery

closing connections: 13.2.2. Error Handling and Clean Up

common user roles: 6.1.1. User Management

connecting to, using Python DB-API: 10.1.1. The Database Connection

creating: 3.2. Database Creation

9.1.2. Setting Up the Database and Program

deleting tables from: 3.3. Table Management

6.1.2.1. GRANT and REVOKE

denormalizing: 5.2.1. Host Application Tuning

designing: 7. Database Design

10.3. Applied DB-API

dumping: 4.4.1. mysqldump

normalizing: 5.2.1. Host Application Tuning

7.2. Normalization

opening/using connections with PHP: 11.3.2. Opening and Using a Database Connection

privileges that apply to: 6.1.2.1. GRANT and REVOKE

querying: 3.7. Queries

referencing: 15.1.2. Identifiers

security: 6.1. Database Security

privilege management: 6.1.2. Privilege Management
user management: 6.1.1. User Management

selecting: 15.2. SQL Commands

updating: 3.6.3. Updates

web applications interacting with: 1.5. MySQL Applications

DATADIR/my.cnf file: 4.1.1. File Locations

DataSource interface (javax.sql): 13.1.2.1. Data source connectivity

DATE data type: 3.4. MySQL Data Types

3.4.5. Other Kinds of Data
16.3. Date Data Types
19.1. Data Types

date data types: 16.3. Date Data Types

date functions: 3.9.4.1. Date functions

Date object (Python DB-API): 10.1.4. Other Objects

DATE_ADD( ) function: 17.2.2. General Functions

DATE_FORMAT( ) function: 3.9.4.1. Date functions

17.2.2. General Functions

DateFromTicks( ): 10.1.4. Other Objects

DATE_SUB( ) function: 17.2.2. General Functions

DATETIME data type: 3.4. MySQL Data Types

3.4.5. Other Kinds of Data
16.3. Date Data Types
19.1. Data Types

DAYNAME( ) function: 17.2.2. General Functions

DAYOFMONTH( ) function: 17.2.2. General Functions

DAYOFWEEK( ) function: 17.2.2. General Functions

DAYOFYEAR( ) function: 17.2.2. General Functions

DB-API (Python)

connecting to databases: 10.1.1. The Database Connection
cursors in: 10.1.2. Cursors
database applications using: 10.3. Applied DB-API
encapsulating SQL data types: 10.1.4. Other Objects
MySQLdb module: 20.1. Module: MySQLdb
parameterized SQL and: 10.1.3. Parameterized SQL

db attribute (MySQLdb module): 20.1.3. Connection Attributes

DB class: 9.3.2. Implementing the Model

9.3.2.7. The DB class

db property (twz JDBC driver): 13.1.2.2. Driver manager connectivity

db table: 6.1.2.2. The security tables

primary key of: 6.1.2.2. The security tables
schema for: 6.1.2.2. The security tables

DBA role in MySQL installations: 6.1.1. User Management

DBD (DataBase Driver) module: 9. Perl

$dbh variable: 9.1.1. Basic Perl Example

DBI module (Perl): 9.1. Introduction to DBI

basic example: 9.1.1. Basic Perl Example
error handling and attributes: 9.1.3. Error Handling and Attributes

dbmdDB property (twz JDBC driver): 13.1.2.2. Driver manager connectivity

dbmdMaxRows property (twz JDBC driver): 13.1.2.2. Driver manager connectivity

dbmdPassword property (twz JDBC driver): 13.1.2.2. Driver manager connectivity

dbmdUser property (twz JDBC driver): 13.1.2.2. Driver manager connectivity

dbmdXcept property (twz JDBC driver): 13.1.2.2. Driver manager connectivity

DBMS (database management system): 1.1. Relational Databases

DB.pm module: 9.3.2. Implementing the Model

Debian package manager, adding PHP and MySQL support using: 11.2.1. Getting Started Under Unix

debugFile property (twz JDBC driver): 13.1.2.2. Driver manager connectivity

debugging

mysql_debug( ) and: 19.2. Functions
mysql_dump_debug_info( ) and: 19.2. Functions

debugRead property (twz JDBC driver): 13.1.2.2. Driver manager connectivity

debugWrite property (twz JDBC driver): 13.1.2.2. Driver manager connectivity

DECIMAL data type: 16.1. Numeric Data Types

19.1. Data Types

DECODE( ) function: 17.2.2. General Functions

DEFAULT attribute: 15.2. SQL Commands

--default-character-set=CHARSET option: 3.7.3.2. Localized sorting

--defaults-extra-file=filename command-line option: 4.1.1. File Locations

DEGREES( ) function: 17.2.2. General Functions

degrees in relationships: 7.2.3. Relationships

deinit routine

aggregate UDF: 14.1.2.5. deinit

standard UDF: 14.1.1. Standard Functions

14.1.1.3. The deinit routine

DELAY_KEY_WRITE option: 15.2. SQL Commands

DELETE privilege: 6.1.2.1. GRANT and REVOKE

loading UDFs (user-defined functions): 14.1.3. Calling a UDF

DELETE statement: 3.6.5. Deletes

15.2. SQL Commands
EXPLAIN SELECT command and: 5.2.2.2. EXPLAIN SELECT
issued by remove method (Model class): 9.3.1. A Model for Relational Data

delimiters and SELECT statement: 15.2. SQL Commands

denormalizing databases: 5.2.1. Host Application Tuning

DESC keyword: 3.7.3.1. Basic ordering

limiting query results: 3.7.4. Limiting Results

Descartes, Alligator: 9.1. Introduction to DBI

DESCRIBE statement: 3.3. Table Management

15.2. SQL Commands

description attribute (MySQLdb module): 20.1.5. Cursor Attributes

designing databases: 7. Database Design

detecting table errors: 4.6. Table Maintenance and Crash Recovery

Deutsch, L. Peter: 1.2. The History of MySQL

developer role in MySQL installations: 6.1.1. User Management

development environment: 6.1.1. User Management

digital certificates: 6.3.1.1. User management

direct compromise

network security and: 6.2.3.3. Direct compromise
protecting application server against: 6.3.1.2. Resource protection

directory servers, storing users in: 6.3.1.1. User management

dirty reads: 8.2.2.1. Transaction isolation levels

DISTINCT keyword: 15.2. SQL Commands

distributed architecture and database applications: 8.1.2. Distributed Application Architecture

division operator (/): 3.8. SQL Operators

17.1.2. Arithmetic Operators

document root of web servers: 11.1. Introducing PHP

11.2.1. Getting Started Under Unix

doGet( ): 13.4. A Guest Book Servlet

dollar sign ($)

extended regular expression: 3.8.4. Pattern Matching
variable identifier in PHP: 11.1.1. A Short Language Primer

doPost( ): 13.4. A Guest Book Servlet

DOUBLE data type: 16.1. Numeric Data Types

19.1. Data Types

double quotes (""), for quoting identifiers: 15.1.2. Identifiers

do...while loops in PHP: 11.1.1. A Short Language Primer

downloading MySQL: 2.1. Preparation

driver manager connectivity with JDBC API: 13.1.2.2. Driver manager connectivity

DriverManager class: 13.1.2.2. Driver manager connectivity

drivers, JDBC: 13.1. The JDBC API

13.1.2.2. Driver manager connectivity
classifications of: 13.1. The JDBC API

DROP DATABASE statement: 3.2. Database Creation

15.2. SQL Commands
ending transactions with: 3.9.2. Transactions

DROP FUNCTION statement: 15.2. SQL Commands

DROP INDEX statement: 15.2. SQL Commands

DROP privilege: 6.1.2.1. GRANT and REVOKE

DROP statement: 15.2. SQL Commands

DROP TABLE statement: 3.3. Table Management

15.2. SQL Commands
ending transactions with: 3.9.2. Transactions

DSOs (dynamic shared objects) and PHP modules: 11.2.1.1. Installation problems

dumping databases: 4.4.1. mysqldump

dynamic database access: 13.3. Dynamic Database Access

dynamic shared objects (DSOs) and PHP modules: 11.2.1.1. Installation problems

dynamic SQL, processing: 13.3.2. Processing Dynamic SQL

Symbols & Numbers | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z