MySQL, Second Edition

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] [X] [Y] [Z]

data

     binary

     casting

     deleting

     displaying

     encrypting/decrypting

     formatting 2nd

     grouping

     importing

     inserting

     limiting returns

     selecting from tables 2nd

     sorting

     updating

     validating

Data Definition Language (DDL)

data directory 2nd

data hash

Data Manipulation Language (DML)

data types [See also specific data types.]

     accounting

     changing

     choosing

     date/time 2nd 3rd 4th

     numeric 2nd

     string

     text 2nd

Data-Dumper

database creation

     basic procedure for

     binary data

     data types

     query result pages

     with mysqladmin utility

database management system (DBMS)

database models

DATABASE() function 2nd

$database_connection variable

databases

     1NF 2nd

     2NF

     3NF

     backups

     closing connection 2nd

     connections to (Java)

     connections to (Perl) 2nd

     connections to (PHP)

    creating [See database creation.]

     deleting 2nd

     designing

     displaying current

     dropping 2nd

     error handling

     joins 2nd

     listing available

     maintenance

     modifying

     multiple

     names 2nd 3rd

     normalization 2nd 3rd

    relational [See relational databases.]

     relationships

     removing data from

     restoring

     script interaction

    security [See security.]

     selecting 2nd 3rd

date columns

DATE data type 2nd

date fields

DATE() function 2nd

DATE_ADD() function 2nd 3rd

DATE_FORMAT() function 2nd 3rd 4th

DATE_SUB() function 2nd 3rd

DATEDIFF() function 2nd 3rd 4th

dates

     calculating

     data types 2nd 3rd

     formatting 2nd 3rd 4th

     functions 2nd

     invalid

     showing

DATETIME data type 2nd

DAYNAME() function 2nd

DAYOFMONTH() function 2nd

DB Tools Software

DBD modules 2nd 3rd

$dbh variable

DBI Documentation Web site

DBI modules 2nd 3rd

DBMS (database management system)

DDL (Data Definition Language)

debugging query problems

DECIMAL data type 2nd 3rd

DECLARE statement 2nd

DECODE() function 2nd

DEFAULT description

defined() function

DELETE command

DELETE event triggers

DELETE FROM query

DELETE keyword

DELETE privilege 2nd

deleting

     data

     databases 2nd

     routines

     tables 2nd 3rd

     users

DES_DECRYPT() function 2nd

DES_ENCRYPT() function 2nd

Developer Shed Web site

die() function 2nd

disconnect() function

display_errors setting

DISTINCT() function 2nd

DMCInsights.com

.dmg file

DML (Data Manipulation Language)

do() function

DOS prompt, xiv 2nd 3rd

dot syntax

DOUBLE data type 2nd

DriverManager

drivers 2nd 3rd

DROP COLUMN clause 2nd

DROP command

DROP DATABASE command

DROP INDEX clause 2nd

DROP keyword

DROP privilege 2nd

DROP TABLE command

DROP TRIGGER command

dropping

     databases 2nd

     indexes 2nd

     stored routines

     tables

     triggers

     views

$dsn variable