MySQL Phrasebook

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]

data manipulation

     columns, updating

     queries, testing inside transactions

     rows, deleting

     safety tips

data storage [See storing data in tables. ]

Database Driver (DBD)

Database Interface (DBI)

databases [See also queries; tables.]

     backups

         full backups

         incremental backups

     connecting to

         C API

         Perl

         PHP

     creating

         CREATE DATABASE command

         prerequisites

     default database, setting

     deleting

     disconnecting from

         C API

         Perl

     how they work

     indexes

         creating 2nd

         deleting

     listing

         all databases 2nd

         filtered list of databases

     renaming

     restoring

         from full backups

         from incremental backups

     structure of

DATE_ADD() function 2nd

DATE_SUB() function

dates

     adding to tables

     finding

DBD (Database Driver)

DBI (Database Interface)

DECIMAL-type columns

default database, setting

degree (tables)

DELAY_KEY_WRITE table option

DELETE command

DELETE privilege

deleting

     columns

     databases

     indexes

     rows

         DELETE command

         from multiple tables

     tables

     users

DESCRIBE command

designing tables

     book table

     candidate keys

     columns

     loan table

     person table

     primary keys

disabling

     network access

     user authentication

disconnecting from databases

     C API

     Perl

DISTINCT clause (SELECT command)

DROP COLUMN command

DROP DATABASE command

DROP INDEX command

DROP privilege

DROP TABLES command

DROP USER command

dropping [See deleting. ]