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] UNDEFINED algorithm clauses 2nd underscore (_) pattern-matching operatorsUNION keyword LIMIT clauses ORDER BY clauses SELECT statements 2nd 3rd UNIQUE clauses unique indexes UNIQUE indexes 2nd unique indexes creating 2ndUNIQUE 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 5thupdating tables DELETE statements 2nd 3rd UPDATE statements 2ndupdating 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 variablesUSE statements databases, selecting/changing as defaultuser 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 |