A

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]

access controls
     mistakes, preventing
     overview 2nd
     user accounts 2nd 3rd 4th
Administrator (MySQL). [See MySQL Administrator] [See MySQL Administrator]
advantages of (MySQL)
AFTER
     versus BEFORE
Against()
     full-text searches 2nd 3rd 4th
aggregate functions
     ALL argument
    AVG()
         limitations of
         overview 2nd
     combining 2nd
    COUNT()
         DISTINCT arguments
         overview 2nd
     DISTINCT argument 2nd
     DISTINCT arguments 2nd
         MIN()/MAX() interaction
     joins, utilizing 2nd
    MAX()
         non-numeric data 2nd
         overview 2nd
    MIN()
         non-numeric data
         overview 2nd
     naming aliases
     overview 2nd
    SUM()
         multiple columns
         overview 2nd
aliases
    aggregate functions
         naming
     alternative uses
     concatenating fields 2nd
     table names 2nd
ALTER TABLE statements 2nd 3rd
ANALYZE TABLE
anchors (regular expressions 2nd
AND
     definition of
     OR, combining
     OR, combining. [See also OR]
     WHERE clauses, combining
AND operator
     WHERE clauses, combining
application filtering
     compared to SQL
AS keyword 2nd
ASC
     utilizing
asterisk wildcard
     columns, retrieving
asterisk wildcards
     columns, retrieving 2nd
AUTO INCREMENT 2nd 3rd 4th
auto increment
     description of
autocommit flags
AVG()
     limitations of
     overview 2nd
AVG() function
     DISTINCT arguments 2nd