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] caches

     MySQL Server memory usage         host caches         query caches         table cachescaches (key)     creating 2nd 3rd    MyISAM tables

         assigning to

         preloading indexes from     server performanceCALL statements

     stored procedures, invoking

canceling

     statements

CASCADE modifiers     FOREIGN KEY clauses

CASE construct 2nd 3rdcase sensitivity

     client program command options     FULLTEXT indexes     identifiers (SQL statements) 2nd     reserved words as identifiers (SQL statements)     string expressions 2nd

         binary strings 2nd 3rd 4th 5th

         literal strings

         nonbinary strings

     user variables

CASE statements

     stored routine conditional testing 2nd

Catalogs section (MySQL Administrator)

CEILING() functions

CHANGE MASTER statements

changing

    mysql client output formats

         batch mode

         interactive mode

    passwords         in user accounts 2nd

    views

         ALTER VIEW statements

CHAR data types

     character sets 2nd CHAR LENGTH() functions 2nd 3rd CHAR string data type 2nd 3rd

CHARACTER SET option (CREATE DATABASE statements) CHARACTER SET string column attribute 2ndcharacter sets     availability of, displaying 2nd

     CHAR data types 2nd     MySQL support of, configuring     required disk space, reducing     VARCHAR data typescharacteristics clauses     COMMENT values     DETERMINISTIC values

     LANGUAGE SQL values

     NOT DETERMINISTIC values 2nd     SQL SECRUITY DEFINER values 2nd     SQL SECRUITY INVOKER values

CHECK TABLE statements

     InnoDB table maintenance

     table maintenance 2nd

checking     SQL mode (MySQL Server)

clearing     SQL mode (MySQL Server)

client (mysql)     batch mode 2nd         changing output format    client/server architectures         communication protocols 2nd

         operational overview 2nd 3rd

         optimizers

         server connection methods 2nd

         SQL parsers

         storage engine tiers 2nd

    commands

         accessing command lists

         information display example 2nd

         long/short forms 2nd

    connection buffers

         MySQL Server memory usage

     databases, selecting as default 2nd

     input-line editing

     interactive mode         canceling statements

         changing output format

         error statements

         invoking from command-line

         statement terminators 2nd 3rd 4th         statements, command-line execution     mysql

    prepared statements         usage example 2nd     quitting     script files

         error statements         processing via command-line         processing via SOURCE command     server-side help, accessing 2nd 3rd    updates         --safe-updates optionclient access control

     --skip-grant-tables option

     connection request checks 2nd 3rd     disabling     FLUSH PRIVILEGES statements

     FLUSH STATEMENT statements

    grant tables

         Host values

         User values 2nd     resource limit checks 2nd

     stages of 2nd     statement privilege checks

client accounts    security         deleting anonymous accounts         granting privileges to         network access 2nd 3rd 4th

client programs

    command options

         case sensitivity

         default values

         host machine specifications

         syntax

     databases, selecting as default 2nd

     defining

     graphical client/server connections

     invoking

         default option values

    mysqlcheck

         --analyze option

         --auto-repair option         --check option

         --check-only-changed option

         --extended option

         --fast option

         --medium-check option         --quick option         --repair option

         table maintenance 2nd 3rd 4th 5th         versus myisamchk utility 2nd    mysqlshow         accessing database metadata 2nd 3rd

    option files         !include directives         !includedir directives         --defaults-extra option         --defaults-file option         creating/modifying         locating

         organization of

         writing options in    server connection information options         --password 2nd

         --user

     server connection options

         --host 2nd 3rd

         --port 2nd         --protocol 2nd 3rd 4th

         --shared-memory-base-name 2nd         --socket 2nd

         specifying     supported options, determining     version, determiningclient/server architectures     components of 2nd 3rd

client/server connectors

     MySQL Connector/J 2nd

     MySQL Connector/NET 2nd

     MySQL Connector/ODBC 2nd

clients

     data locking 2nd

         advisory locks 2nd 3rd 4th 5th 6th 7th

         deadlocks

         explicit locks 2nd 3rd 4th 5th

         implicit locks 2nd 3rd

         lock levels

         row locks

         table locks 2nd 3rd 4th 5th

clients (mysql)     server connectors

         MySQL Connector/J 2nd

         MySQL Connector/NET 2nd

         MySQL Connector/ODBC 2nd

Clone User feature (MySQL Administrator, User Administration section)Cluster (MySQL)     backups

     network security COLLATE option (CREATE DATABASE statements) COLLATE string column attribute 2ndcolumn atttributes

    general column attributes         DEFAULT 2nd         NOT NULL         NULL    numeric column attributes         AUTO INCREMENT 2nd 3rd 4th 5th 6th 7th 8th 9th 10th         MyISAM storage engines 2nd

         UNSIGNED 2nd

         ZEROFILL     overview of 2nd    string column attributes

         BINARY 2nd

         CHARACTER SET 2nd

         COLLATE 2nd

column subqueriescolumns

     adding/dropping     aliases 2nd

    comparisons         ALL keywords 2nd         ANY keywords 2nd 3rd         EXISTS keywords 2nd         IN keywords 2nd

         NOT IN keywords

         scalar subqueries 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th

         SOME keywords

     data retrieval 2nd 3rd

         explicit database specification

         renaming retrieved columns

     modifying

     names, qualifying 2nd 3rd

    NOT NULL columns

         declaring in indexes 2nd

     positioning

    qualified names

         identifiers (SQL statements)

     specifc privileges     trigger references 2nd

columns (tables)

    prefixes

         FULLTEXT indexes

columns (views)     aliases 2nd     names 2nd

Com select server status variables Com server status variablescomma (,) operators     inner joins, writing 2nd 3rd 4th 5th 6th 7th 8th

COMMENT values (characteristics clauses)comments     in statements (SQL) 2nd communication protocols 2ndcomparing    strings         case sensitivity 2nd 3rd 4th 5th 6th 7th 8th 9th

         pattern-matching 2nd 3rd 4th 5th 6th

comparison functions     BETWEEN()     GREATEST() 2nd

     IN() 2nd

     INTERVAL()

     LEAST() 2nd

comparisons    columns

         ALL keywords 2nd         ANY keywords 2nd 3rd

         EXISTS keywords 2nd         IN keywords 2nd         NOT IN keywords         scalar subqueries 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th         SOME keywords

    rows

         row subqueries 2nd 3rd

compiled-in optional storage engines

compiling

     storage engines

Complete distributions (MySQL binary distributions)

complete MySQL installations

     components of 2nd

composite indexes

     creating

     leftmost index prefixes 2nd

compound statements

     in stored routines 2nd

     stored routines         defining 2nd

     triggers 2nd

compressed row-storage formats (MyISAM tables) 2nd 3rd 4th

compressed storage format (MyISAM storage engines)

CONCAT WS() functions 2nd 3rd 4th CONCAT() functions 2nd 3rd     scalar subqueries

concatenating     row data retrieval results 2nd 3rdconcurrent inserts     MyISAM tables

conditional testing    stored routines         CASE statements 2nd         IF statementsconditions     CONTINUE handlers     in stored routines 2nd

     NOT FOUND

     SQLEXCEPTION     SQLWARNING Configure Service tab (MySQL Administrator, Service Control section)

configure-service mode (MySQL Administrator), accessing 2nd

configuring

     disks for MySQL optimal performance

     hardware for MySQL optimal performance 2nd     MySQL server memory parameters

         global parameters 2nd 3rd 4th 5th 6th 7th 8th 9th 10th         global parameters, storage engine selection

         per-client parameters 2nd 3rd     MySQL-supported character sets     replication 2nd 3rd         slave requirements         unique server ID values 2nd

    server connections

         in MySQL Query Browser

Connection dialog (MySQL Query Browser)

     connection management 2nd

     New Instance Connection command

     server connections, configuring

Connection Editor (MySQL Query Browser)

connection information options (client programs/servers)

     --password 2nd

     --user

connection methods (client/server) 2nd

connection options (client programs/servers)

     --host 2nd 3rd

     --port 2nd     --protocol 2nd

         named-pipe connections 2nd

         shared-memory connections

         TCP/IP connections 2nd

     --shared-memory-base-name 2nd     --socket 2nd     specifying

connection request checks (client access control) 2nd 3rd Connections section (MySQL Querey Browser, Options dialog) connectors (MySQL)     MySQL Connector/J 2nd

     MySQL Connector/NET 2nd     MySQL Connector/ODBC 2nd const values (type output columns) CONTINUE handlerscontrol flow functions     CASE construct 2nd 3rd     IF() 2nd

CONVERT TZ() functions 2nd

converting    subqueries         to inner joins 2nd 3rd

         to outer joins 2nd

converting type (input data handling)

cooperative locks [See advisory locks]

correlated subqueriesCOUNT() aggregate functions

     NULL values     SELECT statements 2nd 3rd

COUNT() functions     inner joins CREATE DATABASE statement 2nd     CHARACTER SET option     COLLATE option

CREATE FUNCTION statements

    characteristics clauses

         COMMENT values

         DETERMINISTIC values

         LANGUAGE SQL values

         NOT DETERMINISTIC values 2nd

         SQL SECURITY DEFINER values 2nd

         SQL SECURITY INVOKER calues

     routine body clauses

         RETURNS values

     stored routines, defining 2nd

CREATE INDEX statements

     indexes, adding to tables 2nd

CREATE PROCEDURE statements    characteristics clauses

         COMMENT values

         DETERMINISTIC values

         LANGUAGE SQL values

         NOT DETERMINISTIC values 2nd         SQL SECURITY DEFINER values 2nd         SQL SECURITY INVOKER values

     routine body clauses         RETURNS values     stored routines, defining 2nd CREATE TABLE LIKE statements 2nd

CREATE TABLE SELECT statements 2nd 3rd CREATE TABLE statements     ALTER TABLE option 2nd     AVG ROW LENGTH option 2nd     DATA DIRECTORY option 2nd     ENGINE clauses 2nd     ENGINE option

     IF NOT EXISTS clauses

     INDEX clauses     INDEX DIRECTORY option 2nd     KEY keywords

     MAX ROWS option 2nd 3rd

     PRIMARY KEY keywords 2nd 3rd

     UNIQUE keywords 2nd 3rd 4th

CREATE TEMPORARY TABLE statements CREATE TRIGGER statements 2nd

CREATE USER statements 2ndCREATE VIEW statements

     ALGORITHM clauses         syntax of 2nd 3rd     OR REPLACE clauses 2nd 3rd     privilege requirements     syntax of 2nd

     WITH CHECK OPTION clauses

CROSS JOIN keywords [See INNER JOIN keywords]

cross-plaform interoperability

     MySQL

CSV storage engines

CURRENT DATE() functions

CURRENT TIME() functions

CURRENT TIMESTAMP() functions

cursors

     in stored routines 2nd

customizing

     Result Area display (MySQL Query Browser)