D



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
     autocommit mode
     DELETE command
     filtering on exact values
     filtering on range of values
     grouping
     indexes
         compound
         CREATE INDEX command
         defining key columns
         dropping
         foreign key constraints with InnoDB
         full-text
         partial
         viewing on table
     INSERT command
         default column values
         inserting row using query
         multiple rows
     keys
     loading from file
     maintenance trigger
     REPLACE command
     summarizing with aggregate functions
         AVG( )
         COUNT( )
         MAX( )
         MIN( )
         SUM( )
     transactions, MySQL
     UPDATE command
Data Definition Language
    databases
         altering
         character sets
         collations
         creating
         dropping
    tables
         altering
         autoincrementing column
         creating
         default values
         dropping
         storage engines
         temporary
         using queries to create
Data Manipulation Language
     autocommit mode
     DELETE command
     INSERT command
         default column values
         inserting row using query
         multiple rows
     loading from file
     REPLACE command
    transactions
         MySQL
         reasons for using
         rolling back
     UPDATE command
Data Source Administrator window
Data Source Name (DSN)
data sources
data types
    database design
         binary large object
         character
         date
         decimal
         integer
         text
         time
         variable character
     tables
Database Interface (DBI), Perl
database level routines
database switch, mysql client program
database-management system (DBMS)
databases
     altering
     anatomy
     character sets
     collations
     creating
    designing
         data types
         naming tables and columns
         normalization
         relationships
     dropping
     lists, retrieving (SELECT statement)
    MySQL
         capturing output (mysql client program)
         commands, editing (mysql client program)
         connecting (mysql client program)
         connection status, viewing (mysql client program)
         exiting (mysql client program)
         query output formats (mysql client program)
         selecting (mysql client program)
         SQL command entry (mysql client program)
         zero record retrieval (mysql client program)
     reasons for using MySQL
     records, order of
     referential integrity
     relational
     SQL (Structured Query Language)
    tables
         altering
         autoincrementing column
         creating
         default values
         dropping
         storage engines
         temporary
         using queries to create
DATE data types
DATE FORMAT( ) function, format characters
date functions, complete listing of (MySQL.com)
date operators, representational formats
DATEDIFF( ) function, date difference computations
dates
     arithmetic operators
     data types
     formatting (DATE FORMAT( ) function)
     functions
         CONVERT TZ( )
         CURDATE( )
         DATE FORMAT( )
         DATEDIFF( )
         EXTRACT( )
         NOW( )
         TIMEDIFF( )
         UTC DATE( )
         UTC TIME( )
         UTC TIMESTAMP( )
     representational formats
     storing values in columns
     validation
DATETIME data types
DBD module, Perl
     connecting to MySQL
     executing a query
     fetching query data
     finding query information
     resource cleanup
DBI (Database Interface), Perl
DBMS (database-management system)
dbname argument
Debug binaries
DECIMAL data type
decimals, data types
DECLARE command
DEFAULT keyword, tables
default values, tables
DEGREES( ) function
DELETE command, data manipulation
DELETE privilege
DELETE trigger
delimiters
     character
     strings
descending sort orders (DESC keyword)
DESCRIBE command 2nd
designing databases
    data types
         binary large object
         character
         date
         decimal
         integer
         text
         time
         variable character
     naming tables and columns
     normalization
     relationships
Developer Zone
DISTINCT keyword
division (/) operator
downloads
     MySQL installation
     ODBC (Open Database Connectivity)
drivers, data source selection
DROP DATABASE command
DROP INDEX command
DROP keyword, altering tables
DROP privilege
DROP TABLE command
DROP TABLE IF EXISTS command
DROP TRIGGER command
DROP USER command
DROP VIEW command
dropping
     databases
     indexes
     primary keys
     stored routines
     tables
     triggers
     views
DSN (Data Source Name)
duplicated indexes
dynamic client libraries, Linux/UNIX server installation




Sams Teach Yourself MySQL in 10 Minutes
Sams Teach Yourself MySQL in 10 Minutes
ISBN: 0672328631
EAN: 2147483647
Year: 2006
Pages: 165
Authors: Chris Newman

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net