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] parameter browser (MySQL Query Browser, Information Browser)

parameters     IN 2nd     INOUT     OUT 2nd    stored routines         declaring in 2nd 3rd parsers (SQL)

PASSWORD() functions

passwords     root accounts     user accounts 2nd 3rd

     user accounts, changing in 2nd

pattern-matching

     % (percent symbol) operators 2nd

     (backslash) operators     _ (underscore) operators

     LIKE operators 2nd 3rd         NULL values

         RAND() functions     NOT LIKE operatorsper-client parameters (MySQL server)     configuring 2nd 3rd percent symbol (%) pattern-matching operators 2nd

performance

    application performance

         enhancing via stored routines 2nd

    disk space

         reducing, via character sets

    memory

         storage engine usage

    optimization strategies

         database tables 2nd

         databases

         disk activity distribution 2nd

         disk configurations

         disk usage

         filesystems 2nd         hardware configurations 2nd

         log files

         MyISAM tables

         MySQL installation

         network speeds         OS limitations         temporary file storage

    servers         key caches    table updates         index effects on

perror command-line utility 2nd    error messages         interpreting phantoms 2ndportability (binary backups)     InnoDB tables 2nd     MyISAM tables 2nd

positioning

     columns possible keys output columns (EXPLAIN statements)pound sign (#) comments

     in statements (SQL)

prefixes

    leftmost index prefixes

         optimization strategies 2nd prefixes (columns), indexing (optimization strategies) 2nd 3rd 4th 5th

PREPARE statements 2ndprepared statements (SQL)

     benefits of     creating 2nd     deallocating     executing 2nd     mysql client usage example 2nd

presizing

     MyISAM tables

PRIMARY KEY clauses

     AUTO INCREMENT numeric column attribute

PRIMARY KEY indexes

PRIMARY KEY keywords

     CREATE TABLE statements 2nd 3rd

primary keys

     AUTO INCREMENT attributes 2nd

     creating 2nd 3rd 4th

privilege tables

    upgrades

         security 2nd

privileges     DELETE statements

     FLUSH PRIVILEGES statements

     global

     INSERT statements

     LOAD DATA INFILE statements    network privileges         granting to user accounts

     REPLACE statements    SELECT         trigger column references     specific database

     specific stored routine     specific table     specific table column     specifiers     statements privilege checks (client access control)     stored routines 2nd 3rd    SUPER

         trigger creation/deletion

     TRUNCATE TABLE statements    UPDATE         trigger updates

     UPDATE statements

    user account management

         administrative privileges list

         database-access privileges list 2nd         global privileges

         privilege specifiers         PROCESS

         required privileges 2nd         SELECT         SHUTDOWN         specific database privileges         specific stored routine privileges

         specific table column privileges

         specific table privileges

         SUPER

         UPDATE

     user accounts, granting to 2nd 3rd

     user accounts, revoking from 2nd 3rd

     user accounts, viewing in 2nd

privilges

     views requirements 2nd

PROCEDURE ANALYSE()

     table optimization 2nd 3rd

procedures

     stored procedures [See also stored routines]

         ALTER PROCEDURE statements         displaying metadata 2nd

         DROP PROCEDURE statements

         IN parameters

         INOUT parameters

         invoking via CALL statements         OUT parameters 2nd         retrieving multiple result sets

         syntax of         versus stored functionsPROCESS privileges     user account management

prompts     meanings of 2nd 3rd 4th     mysql