MySQL 5.0 Certification Study Guide

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] [Y] [Z] join analysis

     EXPLAIN statements join buffer size system variablesJOIN keywords [See INNER JOIN keywords]joins     column names, qualifying 2nd 3rd     inner joins         converting subqueries to 2nd 3rd

         COUNT() functions

         FROM clauses 2nd         GROUP BY clauses         HAVING clauses

         ORDER BY clauses

         USING() functions 2nd

         WHERE clauses 2nd 3rd 4th

         writing via comma (,) operators 2nd 3rd 4th 5th 6th 7th 8th         writing via INNER JOIN keywords 2nd

     outer joins         converting subqueries to 2nd

         writing via LEFT JOIN keywords 2nd 3rd 4th 5th         writing via RIGHT JOIN keywords 2nd     overview of 2nd     table names, aliasing 2nd     table names, qualifying