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] LANGUAGE SQL values (characteristics clauses)

LAST INSERT ID() functions     AUTO INCREMENT numeric column attribute 2nd 3rd 4thlaunching     MySQL Administrator 2nd LEAST() functions 2ndLEAVE statements     stored routine transfer control

LEFT JOIN keywords

     outer joins, writing 2nd 3rd 4th 5th leftmost index prefixes 2nd LENGTH() functions 2nd 3rd

libmysqlclient API (C client library)

LIKE clauses

     SHOW statements

     SHOW STATUS statements     SHOW VARIABLES statements 2nd

LIKE clauses (SHOW DATABASES statements) LIKE pattern-matching operators 2nd 3rd

     NULL values     RAND() functionsLIMIT clauses     DELETE statements     query optimization

     SELECT statements 2nd 3rd

     UNION keyword

     UPDATE statements 2nd

limiting

     row selection (data retrieval) 2nd 3rd

LINES clauses

     LOAD DATA INFILE statements 2nd

     SELECT INTO OUTFILE statements 2nd

linking

    symlinking

         tables

Linux

    databases

         moving via symbolic links     multiple server management 2nd

    MySQL Query Browser

         installing 2nd

literal strings

    comparing         case sensitivity LOAD DATA INFILE statements 2nd

     data file format specifiers 2nd 3rd 4th     data file lines, skipping     data file locations, specifying 2nd 3rd     Deleted field

     efficiency of     FIELDS clauses     LINES clauses 2nd     NULL values 2nd     privlege requirements     Records field     Skipped field

     syntax of

     table columns, loading 2nd     table columns, skipping values     table columns, transforming values 2nd

     tables, duplicate records 2nd

     Warnings field

locating

     option files LOCK IN SHARE MODE statement modifiers 2nd

LOCK TABLES statements 2nd     LOW PRIORITY WRITE option

     READ LOCAL option     READ option 2nd     WRITE option locking 2nd     advisory locks 2nd

         GET LOCK() function 2nd

         IS FREE LOCK() function

         IS USED LOCK() function

         RELEASE LOCK() function

     deadlocks

     explicit locks

         table locks 2nd 3rd 4th

     implicit locks 2nd

         lock levels

     lock levels

     row locks

     table locks

         explicit locks 2nd 3rd 4th

    tables         InnoDB storage engines 2nd 3rd

         MERGE storage engines

         MyISAM storage engines 2nd 3rd 4th

locks

    external locks         multiple server managementlog files

     backups    binary log files         processing contents 2nd     InnoDB storage engine configurations 2nd 3rd

     InnoDB storage engines     multiple server management     performance optimization strategies     query optimization, determining potentials for     securitylogs     binary 2nd 3rd

     error 2nd

    error logs         diagnostic messages     general query

    MySQL Server logs

         benefits of 2nd

         binary 2nd

         error 2nd         general query

         slow query    slow query logs

         diagnostic messages 2nd 3rd 4th LONGBLOB string data type LONGTEXT string data typeLOOP statements     stored routine loops 2nd

LOW PRIORITY modifiers

     MyISAM tables 2nd

LOW PRIORITY WRITE option (LOCK TABLES statements)

LOWER() functions