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] named time zones

named-pipe connections     --protocol client program/server connection option 2ndnamespaces     stored routines 2ndnaming     indexes         displaying names

    tables

         qualified names     triggers 2nd     user accounts 2nd 3rd

     view columns 2nd

navigating

     MySQL Administrator main window

     Query window (MySQL Query Browser) 2nd NDBCluster storage engines

     benefits of 2ndnetwork interfaces

     multiple server management 2nd 3rd network interfaces (servers), restricting network security     anonymous accounts, deleting     MySQL Cluster

     root accounts

     user access 2nd 3rd

     user privileges, granting

networking protocols 2nd

networks

     performance optimization strategies

    security

         risks to

New Instance Connection command (MySQL Query Browser)

New Instance Connection command (MySQL Query Browser, Connection dialog)

NO ZERO DATE SQL mode

NO ZERO IN DATE SQL mode

No-install distributions (MySQL binary distributions)

nonbinary string data types 2nd 3rd     characteristics of 2nd

     string column attributes 2nd

     versus binary data types 2nd

nonbinary strings

    comparing         case sensitivity nonclient utilities (MySQL) 2nd

noncorrelated subqueries 2nd nonrepeatable reads nonunique indexes 2nd 3rd normalization (tables) 2nd 3rd [See also optimizing, tables]

     1NF 2nd 3rd     2NF 2nd     3NF 2nd     benefits of NOT DETERMINISTIC values (characteristics clauses) 2nd Not exists values (Extra output columns) 2nd NOT FOUND conditions

NOT IN keywords

     column comparisons NOT LIKE operators NOT NULL column attribute

NOT NULL columns

     indexes, declaring in 2nd

note messages 2nd

NOW() functions NULL column attribute

NULL values     aggregate functions

     AUTO INCREMENT numeric column attributes 2nd 3rd     CONCAT WS() functions 2nd     CONCAT() functions     DISTINCT clauses     IFNULL() functions 2nd

     importing/exporting 2nd

     indexes

     INSERT statements

     IS NOT NULL operators 2nd

     IS NULL operators 2nd

     ISNULL() functions 2nd

     LIKE pattern-matching operators

     user variables

numeric column attributes

     AUTO INCREMENT 2nd

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

         MyISAM storage engines 2nd

         NULL values 2nd 3rd

         PRIMARY KEY clauses     UNSIGNED 2nd

     ZEROFILL

numeric data types

     fixed-point data types

     floating-point data types         DOUBLE         FLOAT

     integer data types         BIGINT 2nd 3rd 4th         INT 2nd 3rd 4th         MEDIUMINT 2nd 3rd 4th

         SMALLINT 2nd 3rd 4th         TINYINT 2nd 3rd 4th     numeric column attributes 2nd     overview of 2nd numeric expressions 2nd