Index D

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

damaged databases.  [See disaster recovery]
data directories
    for multiple servers 
data directory  2nd  3rd 
    location of  2nd  3rd  4th  5th 
    relocating  2nd  3rd  4th  5th 
        database relocation  2nd  3rd 
        determining effect of  2nd 
        InnoDB tablespace relocation  2nd 
        status and log file relocation  2nd 
        table relocation  2nd 
        warning about 
    security  2nd  3rd  4th  5th 
    structure of  2nd 
        access control  2nd  3rd  4th 
        database directories  2nd 
        maximum table size  2nd  3rd 
        naming conventions  2nd  3rd  4th 
        performance issues  2nd  3rd 
        SQL statements for changes  2nd 
        status and log files  2nd  3rd  4th  5th 
        table handlers  2nd  3rd  4th  5th  6th  7th  8th  9th 
data directory initialization
    for MySQL installation  2nd 
DATA DIRECTORY option
    creating tables 
data format options
    mysqldump program  2nd 
    mysqlimport utility  2nd 
data loading
    query optimization  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
data retrieval example
    PHP API  2nd  3rd  4th 
data types  2nd  3rd 
    C API 
        non-scalar  2nd  3rd  4th  5th  6th  7th  8th 
        scalar  2nd 
    column types.  [See column types]
    date and time 
    explicit 
    implicit 
    numeric  2nd 
    string  2nd  3rd  4th 
    type conversion  2nd  3rd  4th  5th  6th 
        date and time types  2nd 
        forcing  2nd  3rd 
        illegal values  2nd 
        testing  2nd  3rd 
    versus column types 
data types.  [See also handles]
data validation
    Perl DBI API  2nd 
data_sources()
    Perl DBI class method  2nd 
database backups
    administration duties 
database browser example
    Web-based applications  2nd  3rd  4th  5th  6th 
database connections
    Perl DBI API  2nd 
database handle attributes
    Perl DBI API  2nd  3rd  4th  5th 
database handle methods
    Perl DBI API  2nd  3rd  4th  5th  6th  7th  8th  9th 
database privileges (grant tables)
    list of  2nd 
database repair and maintenance
    administration duties  2nd 
database replication
    administration duties 
DATABASE() function 
database-level privileges
    granting  2nd 
databases
    advantages of  2nd  3rd  4th  5th  6th  7th 
    altering  2nd  3rd  4th 
    backing up  2nd  3rd 
        InnoDB and BDB tables  2nd 
        preparations for  2nd 
        with BACKUP TABLE statement  2nd 
        with direct-copy methods  2nd 
        with mysqldump utility  2nd  3rd  4th 
        with mysqlhotcopy script  2nd 
        with replication servers  2nd 
    case sensitivity  2nd 
    copying  2nd  3rd 
        advantages and disadvantages  2nd 
        with mysqldump utility 
    creating  2nd  3rd  4th  5th  6th 
    disaster recovery  2nd  3rd 
        auto-recovery capabilities  2nd 
        database recovery  2nd  3rd 
        files needed for  2nd 
        for InnoDB or BDB tables  2nd 
        preventive maintenance schedules  2nd  3rd 
        repairing tables  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th 
        table recovery  2nd  3rd  4th  5th  6th 
    displaying available 
    driver connections  2nd 
    dropping  2nd  3rd  4th 
    in data directory  2nd 
        naming conventions  2nd  3rd  4th 
        relocating  2nd  3rd 
    MyODBC 
        installation on Windows  2nd  3rd 
    names
        case sensitivity 
    naming conventions  2nd  3rd 
    obtaining information about  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th 
    Perl DBI API.  [See Perl DBI API]
    removing
        relocated databases 
    renaming  2nd 
    replication  2nd  3rd 
        setting up master-slave relationship  2nd  3rd  4th 
    sampdb database distribution
        obtaining  2nd 
    security
        reasons for 
    selecting  2nd 
    selecting with PHP API 
    setting default  2nd 
    terminology
        MySQL architecture terminology  2nd  3rd 
        query terminology  2nd 
        structural terminology  2nd  3rd  4th 
    unsupported features  2nd 
    versus spreadsheet programs  2nd 
databases.  [See also sample database]2nd  [See also tables]
datadir variable 
    data directory location 
date and time types  2nd  3rd  4th  5th  6th 
    attributes  2nd 
    DATE type  2nd  3rd 
    DATETIME type  2nd  3rd 
    input formats for  2nd  3rd 
    ranges for 
    selecting  2nd  3rd 
    storage requirements 
    TIME type  2nd  3rd  4th 
    TIMESTAMP type  2nd  3rd  4th  5th  6th 
    type conversion  2nd 
    YEAR type  2nd  3rd 
    year value interpretations  2nd  3rd 
    zero values 
date data types 
date functions  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th 
DATE type  2nd  3rd  4th 
DATE_ADD() function  2nd  3rd  4th  5th 
    forcing type conversion 
DATE_FORMAT() function  2nd  3rd 
DATE_SUB() function  2nd 
dates
    calculations with  2nd  3rd  4th  5th  6th  7th 
DATETIME type  2nd  3rd 
DAYNAME() function 
DAYOFMONTH() function  2nd  3rd 
DAYOFWEEK() function 
DAYOFYEAR() function  2nd 
Db column (grant tables) 
db table (in grant table) 
DBD (database driver) level
    Perl DBI API  2nd  3rd  4th 
DBI (database interface) level
    Perl DBI API  2nd  3rd 
DBI API.  [See Perl DBI API]
DBI modules (Perl)
    installation on UNIX  2nd  3rd 
    installation on Windows  2nd 
DBI_TRACE environment variable
    Perl DBI debugging  2nd  3rd 
deadlock 
debug command 
debugging
    Perl DBI API 
        with print statements  2nd  3rd 
        with tracing  2nd  3rd  4th 
debugging functions
    C API  2nd 
DECIMAL numeric type  2nd  3rd  4th  5th  6th  7th 
declaring
    variables
        Perl DBI API  2nd 
DECODE() function 
decode_bits variable 
DEFAULT attribute
    date and time column types 
    string column types 
default character set
    setting 
DEFAULT CHARACTER SET clause
    creating databases 
DEFAULT CHARACTER SET option
    creating tables 
default character sets
    setting 
default database
    setting  2nd 
DEFAULT keyword
    creating tables 
DEGREES() function 
DELAY KEY WRITE option
    creating tables 
delay_key_write variable 
DELAYED clause
    inserting rows 
DELAYED keyword  2nd 
delayed_insert_limit variable 
delayed_insert_timeout variable 
delayed_queue_size variable  2nd 
DELETE privilege  2nd  3rd 
DELETE statement  2nd  3rd  4th  5th  6th  7th  8th  9th 
    modifying grant tables 
    multiple tables  2nd  3rd 
deleting
    accounts 
    anonymous accounts 
    binary update logs  2nd 
    records  2nd  3rd  4th  5th 
    records from multiple tables  2nd  3rd 
    records from tables
        cascaded deletes 
    server
        from list of services 
    table rows  2nd 
deprecated database handle attributes
    Perl DBI API 
deprecated functions
    C API  2nd  3rd  4th  5th  6th  7th  8th 
    PHP API  2nd 
deprecated statement handle attributes
    Perl DBI API  2nd 
DES KEY FILE option
    flushing caches 
DES_DECRYPT() function 
DES_ENCRYPT() function  2nd 
DESC statement 
DESCRIBE statement  2nd  3rd  4th  5th 
development releases
    when to use 
development time
    selection criteria for APIs  2nd  3rd  4th 
die()
    PHP data retrieval example 
direct-copy methods.  [See copying databases]
directory listing example
    Perl DBI API  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
DISABLE KEYS clause
    altering tables 
DISABLE KEYS statement 
disaster recovery  2nd  3rd 
    auto-recovery capabilities  2nd 
    database recovery  2nd  3rd 
    files needed for  2nd 
    preventive maintenance schedules  2nd  3rd 
    repairing tables  2nd 
        with CHECK TABLE and REPAIR TABLE statements  2nd  3rd 
        with myisamchk utility  2nd  3rd  4th  5th  6th  7th 
    table recovery  2nd 
        for foreign key relationships  2nd 
        for InnoDB or BDB tables  2nd 
        with RESTORE TABLE statement  2nd 
disaster recovery.  [See crash recovery]2nd  [See also backing up]
disconnect()
    Perl DBI database handle method 
disk storage of tables  2nd 
DISTINCT keyword 
    retrieving rows from tables 
DISTINCTROW keyword
    retrieving rows from tables 
division operator (/) 
DO statement  2nd 
do()
    Perl DBI database handle method  2nd 
    processing Perl DBI query results
        without result set  2nd 
dollar sign ($)
    PHP variables 
domain name registration
    selecting ISPs 
dot (.)
    wildcard character 
DOUBLE numeric type  2nd  3rd 
downgrading
    MySQL 
drivers
    database connections  2nd 
DROP COLUMN clause
    altering tables 
drop command 
DROP DATABASE statement  2nd  3rd  4th  5th 
DROP FUNCTION statement 
DROP INDEX clause
    altering tables 
DROP INDEX statement  2nd  3rd  4th 
DROP PRIMARY KEY clause
    altering tables 
DROP privilege  2nd  3rd 
DROP TABLE statement  2nd  3rd  4th  5th 
dropping
    databases  2nd  3rd  4th 
    functions 
    indexes  2nd  3rd 
    tables  2nd  3rd  4th 
dump files
    compressing 
dump files.  [See also mysqldump utility]
dump_results()
    Perl DBI statement handle method 
durability (transactions) 
dynamic attributes
    Perl DBI API  2nd 
dynamic output
    PHP API  2nd 
dynamic variables
    setting