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]

names

    fully qualified table names

         overview 2nd

natural joins

     overview 2nd

nested groups. [See also GROUP BY]

non-numeric data

     MAX() function

     MIN() function

nonmatches

    checking against

         with WHERE clauses 2nd

     compared to NULL

NOT

     definition of

     limitations in MySQL

    utilizing

         in WHERE clauses 2nd

NULL

     AVG() function interaction

     compared to nonmatches

     COUNT() function interaction

     MAX() function interaction

     MIN() function

     SUM() function interaction

     wildcard searches

NULL values

    checking for

         with WHERE clauses 2nd

     tables 2nd

     versus empty strings

numbers, storing efficiently

numeric datatypes 2nd 3rd

numeric manipulation functions

     overview 2nd