MySQL Crash Course

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