Managing and Using MySQL, 2nd Edition

[Symbol][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]

D

data

 caching, in applications

 deleting

 encrypting

 managing

 pulling from MySQL

 writing with PHP

 data directories, setting permissions on

 data models

 methodology for

 data source connectivity with JDBC API , 2nd

data types

 MySQL

 MySQL C API

 Python

 SQL

 database administrator (DBA) role in MySQL installations

 DataBase Driver (DBD) module

    See : entities database entities

 database handles

 closing

 controlling attributes of, using connect()

 returning, using getDB()

    See : DBI module (Perl DataBase Interface module )

 database management system (DBMS)

database servers

 closing connections to

 creating connections to

 dumping debug information

 getting host information

 operating status of

 performance tuning for

 reloading permission tables on

 shutting down

 Database SIG (Special Interest Group)

 DATABASE() function , 2nd

databases

 accessing with JDBC

 administration tasks

 applications

 checking integrity

 closing connections

 common user roles

 connecting to, using Python DB-API

 creating , 2nd

 deleting tables from , 2nd

 denormalizing

 designing , 2nd

 dumping

 normalizing , 2nd

 opening/using connections with PHP

 privileges that apply to

 querying

 referencing

security

 user management

 selecting

 updating

 web applications interacting with

 DATADIR/my.cnf file

 DataSource interface (javax.sql)

 DATE data type , 2nd  , 3rd  , 4th

 date data types

 date functions

 Date object (Python DB-API)

 DATE_ADD() function

 DATE_FORMAT() function , 2nd

 DATE_SUB() function

 DateFromTicks()

 DATETIME data type , 2nd  , 3rd  , 4th

 DAYNAME() function

 DAYOFMONTH() function

 DAYOFWEEK() function

 DAYOFYEAR() function

 db attribute (MySQLdb module)

 DB class , 2nd

 db property (twz JDBC driver)

 db table

 primary key of

 schema for

DB-API (Python)

 connecting to databases

 cursors in

 database applications using

 encapsulating SQL data types

 MySQLdb module

 parameterized SQL and

 DB.pm module

 DBA role in MySQL installations

 DBD (DataBase Driver) module

 $dbh variable

 DBI module (Perl)

 basic example

 error handling and attributes

 dbmdDB property (twz JDBC driver)

 dbmdMaxRows property (twz JDBC driver)

 dbmdPassword property (twz JDBC driver)

 dbmdUser property (twz JDBC driver)

 dbmdXcept property (twz JDBC driver)

 DBMS (database management system)

 Debian package manager, adding PHP and MySQL support using

 debugFile property (twz JDBC driver)

debugging

 mysql_debug() and

 mysql_dump_debug_info() and

 debugRead property (twz JDBC driver)

 debugWrite property (twz JDBC driver)

 DECIMAL data type , 2nd

 DECODE() function

 DEFAULT attribute

 --default-character-set=CHARSET option

 --defaults-extra-file=filename command-line option

 degrees in relationships

 DEGREES() function

deinit routine

 aggregate UDF

 standard UDF

 DELAY_KEY_WRITE option

 DELETE privilege

 loading UDFs (user-defined functions)

 DELETE statement , 2nd

 EXPLAIN SELECT command and

 issued by remove method (Model class)

 delimiters and SELECT statement

 denormalizing databases

 DESC keyword

 limiting query results

 Descartes, Alligator

 DESCRIBE statement , 2nd

 description attribute (MySQLdb module)

 designing databases

 detecting table errors

 Deutsch, L. Peter

 developer role in MySQL installations

 development environment

 digital certificates

direct compromise

 network security and

 protecting application server against

 directory servers, storing users in

 dirty reads

 DISTINCT keyword

 distributed architecture and database applications

 division operator (/) , 2nd

 do...while loops in PHP

 document root of web servers , 2nd

 doGet()

dollar sign ($)

 extended regular expression

 variable identifier in PHP

 doPost()

 DOUBLE data type , 2nd

 double quotes (""), for quoting identifiers

 downloading MySQL

 driver manager connectivity with JDBC API

 DriverManager class

 drivers, JDBC , 2nd

 classifications of

 DROP DATABASE statement , 2nd

 ending transactions with

 DROP FUNCTION statement

 DROP INDEX statement

 DROP privilege

 DROP statement

 DROP TABLE statement , 2nd

 ending transactions with

 DSOs (dynamic shared objects) and PHP modules

 dumping databases

 dynamic database access

 dynamic shared objects (DSOs) and PHP modules

 dynamic SQL, processing