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] general column attributes

     DEFAULT 2nd     NOT NULL     NULL General Options section (MySQL Querey Browser, Options dialog) 2nd general query logs GET LOCK() function 2ndglobal parameters (MySQL server)

     configuring

         InnoDB buffer pools 2nd         InnoDB log buffers         maximum connections allowed

         MyISAM key caches 2nd 3rd

         storage engine selection

         table caches 2nd

global privilegesglobal variables

     displaying     key buffer size

     setting GRANT statements 2nd 3rd     IDENTIFIED BY clauses     ON clauses 2nd     SQL mode upgrades

     syntax of

     TO clauses 2nd

grant table buffers

     MySQL Server memory usage

grant tables 2nd 3rd 4th

     changes, applying

     flushing (security strategies)

     Host values

    upgrades

         security

     user accounts, modifying

     User values 2nd

graphical client/server connections

GREATEST() functions 2ndGROUP BY clauses

     inner joins

     SELECT statements 2nd 3rd 4th 5th

     WITH ROLLUP modifiers 2nd 3rd 4th

GROUP CONCAT() aggregate functions     SELECT statements 2nd 3rd 4thGROUP CONCAT() functions

     SELECT statements 2nd 3rd