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] FEDERATED storage engines 2nd

     operational characteristicsFEDERATED tables     remote host access, configuring 2nd     security 2ndFETCH statements     stored routinesFIELDS clauses

     LOAD DATA INFILE statements

     SELECT INTO OUTFILE statementsfilesystems     performance optimization strategies 2nd

     security 2nd 3rd

         log files

         risks to 2nd

FIRST keywords     ALTER TABLE statements

fixed-length row-storage formats (MyISAM tables) 2nd fixed-point data types

fixed-row storage format (MyISAM storage engines) FLOAT floating-point data type floating-point data types     DOUBLE     FLOAT

FLOOR() functions

FLUSH PRIVILEGES statements

FLUSH STATEMENT statements

flushing grant tables (security strategies)

FOR UPDATE statement modifiers

FOREIGN KEY clauses

     CASCADE modifiers

     ON DELETE CASCADE modifiers

     ON DELETE modifiers

     ON UPDATE CASCADE modifiers

     ON UPDATE modifiers

     syntax of

foreign keys

     InnoDB storage engine support 2nd 3rd 4th 5thfrm files

     MySQL Server storage 2nd

FROM clauses

     inner joins 2nd

     SHOW TABLE statements 2nd     subqueries 2nd FULLTEXT indexes 2nd 3rd 4th

     case sensitivity     column prefixes     MATCH operators     searches

     syntax of function browser (MySQL Query Browser, Information Browser)functions     as identifiers (SQL statements)     stored functions [See also stored routines]         ALTER FUNCTION statements         displaying metadata 2nd

         DROP FUNCTION statements

         IN parameters         invoking         syntax of

         versus stored procedures