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

    connections         via Connection Editor (MySQL Query Browser)    mysql client         input-line editing Editors section (MySQL Querey Browser, Options dialog)emptying     tables

ENCODE() functions

encryption functions     AES DECRYPT() 2nd     AES ENCRYPT() 2nd

     DECODE()

     DES DECRYPT() 2nd

     DES ENCRYPT() 2nd

     ENCODE()     PASSWORD()

ENGINE clauses     ALTER TABLE statements

     CREATE TABLE statements 2ndENGINE option     CREATE TABLE statements ENUM string data type 2nd 3rd 4th 5th eq ref values (type output columns) 2nd

ERROR FOR DIVISION BY ZERO mode (SQL mode)

ERROR FOR DIVISION BY ZERO mode (SQL mode), enabling

ERROR FOR DIVISION BY ZERO SQL mode

error logs 2nd

     diagnostic information

error messages 2nd

     components of

     error logs

    interpreting

         perror command-line utility 2nd 3rd

         SHOW ERRORS statements 2nd

         SHOW WARNINGS statements 2nd 3rd 4th

     slow query logs 2nd 3rd 4th

     sources oferror statements

     mysql client interactive mode

     script files

ESCAPE clauses 2nd

Essentials distributions (MySQL binary distributions) EXAMPLE storage engines EXECUTE privilege characteristic (stored routines)

EXECUTE statements     prepared statements 2nd     user variablesexecuting

     prepared statements 2ndEXISTS keywords     column comparisons 2ndEXIT command     mysql client EXPLAIN statements     join analysis

     MySQL Optimizer information, obtaining 2nd

     optimization    query analysis         output columns 2nd 3rd 4th 5th 6th 7th

         usage example 2nd 3rd 4th 5th 6th 7th 8th

explicit definitions

     table creation 2nd 3rd

explicit locks     table locks

         LOCK TABLES statements 2nd         UNLOCK TABLES statements

exporting/importing data     LOAD DATA INFILE statements 2nd         data file format specifiers 2nd 3rd 4th         Deleted field         duplicate table records 2nd

         efficiency of

         FIELDS clauses

         LINES clauses 2nd

         loading specific table columns 2nd

         privielge requirements

         Records field

         Skipped field

         skipping data file lines

         skipping table column values

         specifying data file locations 2nd 3rd

         syntax of

         transforming table column values 2nd

         Warnings field

     mysqldump command-line client 2nd         --all-databases option

         --databases option

         --fields-enclosed-by option 2nd

         --fields-escaped-by option

         --fields-terminated-by option 2nd         --lines-terminated-by option         --no-create-info option

         --tab option 2nd     mysqlimport command-line client 2nd 3rd 4th 5th         --ignore option         --local option 2nd

         --replace option         fields-enclosed-by option         fields-escaped-by option         fields-terminated-by option 2nd         lines-terminated-by option 2nd     NULL values 2nd     SELECT INTO OUTFILE statements 2nd 3rd

         data file format specifiers 2nd 3rd 4th

         FIELDS clauses         LINES clauses 2ndexpressions (SQL)

     aggregate functions

    comparison functions

         BETWEEN()

         GREATEST() 2nd         IN() 2nd

         INTERVAL()         LEAST() 2nd

     components of 2nd    control flow functions         CASE construct 2nd 3rd         IF() 2nd    encryption functions

         AES DECRYPT() 2nd

         AES ENCRYPT() 2nd

         DECODE()

         DES DECRYPT() 2nd

         DES ENCRYPT() 2nd

         ENCODE()

         PASSWORD()

     examples of 2nd

    mathematical functions

         ABS() 2nd

         CEILING()

         CHAR LENGTH() 2nd

         CONCAT WS() 2nd

         CONCAT() 2nd         FLOOR()

         LENGTH() 2nd

         RAND()

         ROUND() 2nd

         SIGN() 2nd         STRCMP()    NULL-related functions

         CONCAT WS() 2nd         CONCAT()         IFNULL() 2nd         ISNULL() 2nd

     numeric expressions 2nd     string expressions 2nd         case sensitivity 2nd 3rd 4th 5th 6th 7th 8th 9th         pattern-matching 2nd 3rd 4th 5th 6th     temporal expressions     temporal functions         CURRENT DATE()

         CURRENT TIME()

         CURRENT TIMESTAMP()         MAKEDATE() 2nd         MAKETIME() 2nd

         NOW()

external locks

     multiple server management

Extra output columns (EXPLAIN statements) 2nd     Distinct values

     Not exists values 2nd     Range checked for each record values

     Using filesort values     Using index values     Using temporary values     Where used values