index_U

 


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]

UNDEFINED algorithm clauses 2nd
underscore (_) pattern-matching operators
UNION keyword
     LIMIT clauses
     ORDER BY clauses
     SELECT statements 2nd 3rd
UNIQUE clauses
unique indexes
UNIQUE indexes 2nd
unique indexes
     creating 2nd
UNIQUE keywords
     CREATE TABLE statements 2nd 3rd 4th
unique service names
     multiple server management 2nd
unique subquery values (type output columns)
Unix
    databases
         moving via symbolic links
     multiple server management 2nd
     MySQL binary distributions
    MySQL Server
         startup methods 2nd
         startup prerequisites 2nd 3rd
    MySQL Server runtime configurations
         option file search order
UNLOCK TABLES statements
UNSIGNED numeric column attribute 2nd
UPDATE IGNORE SQL mode
UPDATE privilege
     trigger updates
UPDATE privileges
     user account management
UPDATE statements 2nd
     LIMIT clauses 2nd
     optimization
     ORDER BY clauses
     required privileges
     SET clauses 2nd
     WHERE clauses 2nd 3rd 4th
     WITH CHECK OPTION clauses 2nd 3rd
updates
    indexes
         disabling
     MySQL 2nd
    mysql client
         --safe-updates option
     optimization 2nd
    Optimizer
         MyISAM table optimization 2nd
     subqueries 2nd
    tables
         index effects on performance
     views 2nd 3rd 4th 5th
updating
    tables
         DELETE statements 2nd 3rd
         UPDATE statements 2nd
updating data
     DELETE statements
         LIMIT clauses
         mutliple table updates 2nd 3rd
         ORDER BY clauses
         required privileges
         WHERE clauses 2nd
     INSERT statements 2nd 3rd
         adding multiple records to tables 2nd 3rd
         records with duplicate key values 2nd
         required privileges
     REPLACE statements 2nd 3rd 4th
         required privileges
     TRUNCATE TABLE statements 2nd
         required privileges
     UPDATE statements 2nd
         dangers of
         LIMIT clauses 2nd
         mutliple table updates 2nd
         ORDER BY clauses
         required privileges
         SET clauses
         WHERE clauses 2nd 3rd
upgrades
    grant tables
         security
    privilege tables
         security 2nd
    servers
         replication
    SQL mode values
         security 2nd 3rd
UPPER() functions
Uptime server status variables
USE statements
     databases, selecting/changing as default
user accounts
     managing
         administrative privileges list
         applying changes
         changing passwords 2nd
         CREATE USER statements 2nd
         database-access privileges list 2nd
         DROP USER statements 2nd
         global privileges
         GRANT statements 2nd 3rd 4th 5th 6th
         grant tables 2nd 3rd 4th 5th 6th
         granting privileges 2nd 3rd
         privilege specifiers
         PROCESS privileges
         RENAME USER statements 2nd
         required privileges 2nd
         REVOKE statements 2nd 3rd 4th
         revoking privileges 2nd 3rd
         SELECT privileges
         SET PASSWORD statements 2nd 3rd
         SHOW GRANTS statements 2nd 3rd
         SHUTDOWN privileges
         specific database privileges
         specific stored routine privileges
         specific table column privileges
         specific table privileges
         specifying account names 2nd 3rd
         specifying resource limits 2nd
         SUPER privileges
         UPDATE privileges
         viewing privileges 2nd
    modifying
         via grant tables
         via SQL statements
    security
         deleting anonymous accounts
         granting privileges to
         network access 2nd 3rd
User Administration section (MySQL Administrator) 2nd
     Clone User feature
User values (grant tables 2nd
user variables
     case sensitivity
     client connection specificity
     EXECUTE statements
     nonbinary string values
     NULL values
     SELECT statements
     SET statements 2nd
     syntax 2nd
Using filesort values (Extra output columns)
Using index values (Extra output columns)
Using temporary values (Extra output columns)
USING() functions
     inner joins 2nd
UTC (Coordinated Universal Time) 2nd
     TIMESTAMP temporal data types

 


MySQL 5 Certification Study Guide
MySQL 5.0 Certification Study Guide
ISBN: 0672328127
EAN: 2147483647
Year: 2006
Pages: 312

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net