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] ABS() functions 2nd

access privileges     stored routinesACID compilance     InnoDB storage engines 2ndADD clauses     ALTER TABLE statementsadding

    indexes

         to tables 2nd 3rdadding/dropping     columns

administration (database)

     client overview 2nd

     MySQL Administrator

         capabilities of 2nd         requirements of

     mysql command-line client         capabilities of 2nd

     mysqladmin command-line client 2nd 3rd         capabilities of 2nd         command availability     mysqldump command-line client 2nd     mysqlimport command-line client 2nd 3rd 4th

    security

         stored routines 2nd 3rd 4th

     triggers

administrative privileges

     list of

Administrator (MySQL)

     capabilities of 2nd

     configure-service mode, accessing 2nd

     dump files, reloading

    main window

         Backup section 2nd

         Catalogs section

         Health section 2nd

         navigating         Replication Status section

         Restore section

         Server Connections section

         Server Information section 2nd

         Server Logs section 2nd         Service Control section 2nd 3rd 4th         Startup Variables section 2nd

         User Administration section 2nd 3rd     operational mode, selecting     Options dialog     requirements of

     servers, connecting to     starting 2nd     System Tray monitor     table maintenance 2nd     text backups Administrator section (MySQL Querey Browser, Options dialog) advisory locks 2nd

     GET LOCK() function 2nd

     IS FREE LOCK() function     IS USED LOCK() function     RELEASE LOCK() function

AES DECRYPT() functions 2nd

AES ENCRYPT() functions 2nd

aggregate functions

     AVG() 2nd     COUNT() 2nd 3rd

         NULL values     GROUP CONCAT() 2nd 3rd 4th

     MAX() 2nd 3rd     MIN() 2nd 3rd     NULL values     SUM() 2ndALGORITHM clauses

     CREATE VIEW statements 2nd 3rd 4th

     MERGE algorithms 2nd 3rd

     syntax of 2nd 3rd

     TEMPTABLE algorithms 2nd

     UNDEFINED algorithms 2nd

aliases

     columns 2nd

     view columns 2nd

aliasing

     table names 2nd

ALL keywords

     column comparisons 2nd

ALL values (type output columns)

ALLOW INVALID DATES SQL mode ALTER DATABASE statement 2nd

ALTER FUNCTION statements

     stored routines

ALTER PROCEDURE statements

     stored routinesALTER TABLE option     CREATE TABLE statements 2nd

ALTER TABLE statements 2nd     ADD clauses     ENGINE clauses     FIRST keywords

     indexes, adding to tables 2nd     indexes, dropping 2nd     MODIFY clauses     multiple table alterations, specifying ALTER VIEW statementsANALYZE TABLE statements     table maintenance 2nd

anonymous user accounts, deleting

ANSI mode (SQL mode) ANSI QUOTES mode (SQL mode)ANY keywords

     column comparisons 2nd 3rd

API (application programming interfaces)

     libmysqlclient (C client library)

     MySQL AB support 2ndapplication performance

     stored routines, enhancing via 2ndarchitecture (MySQL)

     communication protocols 2nd     operational overview 2nd 3rd     optimizers     SQL parsers     storage engine tiers 2nd

architectures

     master/slave architectures (MySQL replication) 2nd

         slave requirements

    MySQL client/server architecture

         components of 2nd 3rd

ARCHIVE storage engines

assigning

     MyISAM tables to key caches

attributes

    column attributes

         numeric column attributes 2nd 3rd

         overview of 2nd

         string column attributes 2nd 3rd 4th

AUTO INCREMENT attributes     primary keys 2nd

AUTO INCREMENT numeric column attribute 2nd

     LAST INSERT ID() functions 2nd 3rd 4th

     MyISAM storage engines 2nd

     NULL values 2nd 3rd     PRIMARY KEY clausesauto-repair

     MyISAM tables 2ndautocommit mode    disabling         InnoDB storage engines 2nd 3rd

AVG ROW LENGTH option     CREATE TABLE statements 2ndAVG() aggregate functions     SELECT statements 2nd