MySQL 5.0 Certification Study Guide

2017-07-07 02:10:07

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] saving

queries in Query window (MySQL Query Browser) scalar subqueries 2nd column comparisons 2nd ALL keywords 2nd ANY keywords 2nd 3rd EXISTS keywords 2nd

IN keywords 2nd

NOT IN keywords SOME keywords CONCAT() functions

scaling MySQL

multiple server management

data directories 2nd 3rd

external locking InnoDB tablespace files

log files MySQL Instance Manager

network interfaces 2nd 3rd unique service names 2nd replication binary logs CHANGE MASTER statements

configuring 2nd 3rd

configuring, slave requirements

configuring, unique server ID values 2nd

master/slave architectures 2nd

master/slave architectures, slave requirements

master/slave compatibility 2nd

relay logs 2nd

replication threads 2nd 3rd

server upgrades

START SLAVE statements

troubleshooting 2nd

schemas [See databases]

Script Editor (MySQL Query Browser)

script files error statements

processing

via command-line

via SOURCE command

Search button (MySQL Query Browser Result Area)searches FULLTEXT indexes

security database administration stored routines 2nd 3rd 4th triggers

FEDERATED tables 2nd filesystems 2nd 3rd log files risks to 2nd grant tables, flushing log files MySQL installation

secure installation conditions 2nd

Windows security measures MySQL Server 2nd network interfaces, restricting

networks

deleting anonymous accounts

granting user privileges

MySQL Cluster risks to

root accounts user access 2nd 3rd

operating systems 2nd risks to passwords 2nd 3rd root accounts root accounts

SQL mode

ERROR FOR DIVISION BY ZERO mode

Strict mode

TRADITIONAL mode 2nd

stored routine privileges 2nd

upgrades

grant tables

privilege tables 2nd

SQL mode values 2nd 3rd

user accounts

deleting anonymous accounts

granting privileges to

network access 2nd 3rd

SELECT INTO OUTFILE statements 2nd 3rd data file format specifiers 2nd 3rd 4th

FIELDS clauses

LINES clauses 2nd

NULL values 2nd

text backups 2ndSELECT INTO statements store routines, assigning variable values in

SELECT privilege trigger column referencesSELECT privileges user account management

SELECT statements AVG() aggregate functions 2nd column aliases 2nd COUNT() aggregate functions 2nd 3rd data retrieval 2nd aggregating results 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th column retrieval 2nd 3rd 4th 5th

concatenating row results 2nd 3rd

grouping results 2nd 3rd 4th 5th 6th grouping results, multilevel summary values 2nd 3rd 4th grouping results, selecting groups 2nd 3rd

grouping results, sorting 2nd

row retrieval 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th

DISTINCT clauses 2nd 3rd 4th

FOR UPDATE statements modifiers FROM clauses

subqueries 2nd GROUP BY clauses 2nd 3rd 4th 5th

GROUP CONCAT() aggregate functions 2nd 3rd 4th GROUP CONCAT() functions 2nd 3rd HAVING clauses 2nd 3rd HIGH PRIORITY clauses joins

overview of 2nd

LIMIT clauses 2nd 3rd

LOCK IN SHARE MODE statements modifiers 2nd

MAX() aggregate functions 2nd 3rd

MIN() aggregate functions 2nd 3rd

ORDER BY clauses 2nd 3rd 4th 5th 6th

SUM() aggregate functions 2nd

syntax of

UNION keyword 2nd 3rd

user variables

WHERE clauses

row retrieval

select type output columns (EXPLAIN statements)

selecting rows

limiting selections (data retrieval) 2nd 3rd

SERIALIZABLE isolation levels (InnoDB storage engines) 2nd

server

internal temporary tables MySQL Server memory usage Server (MySQL) 2nd

server (mysql) client/server architectures client connection methods 2nd communication protocols 2nd

operational overview 2nd 3rd optimizers SQL parsers storage engine tiers 2ndServer (MySQL) data directory database directories

frm files 2nd

InnoDB storage engine tablespaces/log files server log files status files

storage engine data/index files

disk space usage 2nd

logs

benefits of 2nd binary 2nd

error 2nd general query

slow query manual operation in Windows memory usage buffers

buffers, grant table buffers

buffers, InnoDB storage engine log buffers

buffers, key buffers 2nd

buffers, MEMORY storage engine tables

buffers, mysql client connection buffers

caches

caches, host caches

caches, query caches

caches, table caches

server internal temporary tables

thread handlers

mysqladmin extended-status command-line utility

mysqladmin variables command-line utility

optimizing configuring memory parameters

configuring memory parameters, global parameters 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th

configuring memory parameters, per-client parameters 2nd 3rd

interpreting server information 2nd 3rd 4th 5th 6th 7th 8th 9th

measuring server load status 2nd query cache query cache, determining utilization of 2nd 3rd

query cache, enabling 2nd 3rd runtime configurations option file search order 2nd specifying options 2nd 3rd 4th 5th

security configurations 2nd server load status, measuring 2nd 3rd SET statements SHOW PROCESSLIST statements SHOW STATUS statements LIKE clauses SHOW VARIABLES statements

LIKE clauses 2nd

SQL mode ANSI mode ANSI QUOTES mode

checking

clearing

composite modes 2nd

ERROR FOR DIVISION BY ZERO mode IGNORE SPACE mode

setting, multiple mode names setting, single mode values

STRICT ALL TABLES mode 2nd STRICT TRANS TABLES mode 2nd TRADITIONAL mode SQL mode, setting 2nd starting/stopping

Unix startup methods 2nd

Unix startup prerequisites 2nd 3rd

Windows startup prerequisites 2nd

status files

status variables

Key read requests

Key reads

Opened tables

Qcache hits

Qcache inserts

Qcache lowmem prunes

Qcache queries in cache

Threads connected

status variables, Bytes received status variables, Bytes sent

status variables, Com

status variables, Com select

status variables, displaying 2nd 3rd

status variables, measuring server load status 2nd 3rd status variables, Opened tables status variables, Questions

status variables, Slow queries 2nd status variables, Uptime status variables, uses of system variables

innodb buffer pool size innodb log buffer size join buffer size key buffer size 2nd max connections query cache limit query cache min res unit

query cache size

query cache type 2nd 3rd query cache wlock invalidate read buffer size

sort buffer size

table cache

system variables, displaying 2nd 3rd

system variables, setting 2nd global variables

session variables 2nd time zone tables, loading 2nd

Windows service, operating as 2nd 3rd Server Connections section (MySQL Administrator) Server Information section (MySQL Administrator) 2ndserver log files MySQL Server storage

Server Logs section (MySQL Administrator) 2nd

server-side help

mysql client, accessing from 2nd 3rd

server-wide parameters (MySQL Server)

configuring

InnoDB buffer pools 2nd

InnoDB log buffers

maximum connections allowed

MyISAM key caches 2nd 3rd

storage engine selections

table caches 2nd

servers

--log-queries-not-using-indexes option

client access control --skip-grant-tables option

connection request checks 2nd 3rd

disalbing

FLUSH PRIVILEGES statements

FLUSH STATEMENT statements grant tables, Host values grant tables, User values 2nd

resource limit checks 2nd stages of 2nd statement privilege checks client program connection information options

--password 2nd --user client program connection options --host 2nd 3rd --port 2nd --protocol 2nd 3rd 4th --shared-memory-base-name 2nd

--socket 2nd

specifying graphical client/server connections ID values

server replication configuration 2nd

log files

determining potential queries for optimization

multiple server management data directories 2nd 3rd 4th

external locking log files

MySQL Instance Manager network interfaces 2nd 3rd unique service names 2nd MySQL Administrator connections MySQL Query Browser connections

mysqld 2nd

mysqld-debug

mysqld-max

mysqld-max-nt

mysqld-nt 2nd

network interfaces, restricting

performance

key caches

replication

backups

binary logs

CHANGE MASTER statements

configuring 2nd 3rd

configuring, slave requirements configuring, unique server ID values 2nd

master/slave architectures 2nd

master/slave architectures, slave requirements

master/slave compatibility 2nd

relay logs 2nd replication threads 2nd 3rd server upgrades

START SLAVE statements troubleshooting 2nd storage engines compiling

viewing availability 2nd transaction isolation levels setting at startup 2nd 3rd upgrades replication versus hostsservers (mysql)

client connectors

MySQL Connector/J 2nd MySQL Connector/NET 2nd MySQL Connector/ODBC 2nd

Service Control section (MySQL Administrator) 2nd

Configure Service tab

Start/Stop Service tab 2nd

services (Windows) MySQL Server, operating as 2nd 3rd

session variables displaying

setting 2ndSET clauses INSERT statements UPDATE statements 2nd SET PASSWORD statements 2nd 3rd

SET statements

server system variables, setting

store routines, assigning variable values in 2nd

user variables 2nd

SET string data type 2nd 3rd 4th

SET TRANSACTION ISOLATION LEVEL statements

shared tablespaces

InnoDB storage engine configurations 2nd

explicit control

tablespace characteristics 2nd

InnoDB tables 2nd

shared-memory connections

--protocol client program/server connection option

SHOW CHARACTER SET statements 2nd SHOW COLLATION statements 2nd

SHOW COLUMNS statements

database metadata, accessing 2nd 3rd 4th

LIKE clauses

SHOW CREATE DATABASE statementSHOW CREATE FUNCTION statements stored function metadata, displaying

SHOW CREATE PROCEDURE statements stored procedure metadata, displaying SHOW CREATE TABLE statements 2nd KEY clauses

table storage engines, determining 2nd SHOW CREATE VIEW statements privilege requirements SHOW DATABASES statement 2nd LIKE clausesSHOW DATABASES statements database metadata, accessing 2nd 3rd

LIKE clauses

SHOW ENGINEINNODB STATUS statements 2nd SHOW ENGINES statements 2nd 3rd SHOW ERRORS statements 2nd

SHOW FIELDS statements

database metadata, accessing

SHOW FULL TABLES statements 2nd

SHOW FUNCTION STATUS statements stored function metadata, displaying

SHOW GRANTS statements 2nd 3rd SHOW INDEX statements

database metadata, accessingSHOW KEYS statements database metadata, accessing SHOW MASTER STATUS statementsSHOW PROCEDURE STATUS statements

stored procedure metadata, displaying

SHOW PROCESSLIST statements 2nd

query optimization, determining potential queries for

replication threads, viewing 2nd

SHOW SLAVE HOSTS statements

SHOW SLAVE STATUS statements 2nd

SHOW statements

versus INFORMATION SCHEMA database 2nd

SHOW STATUS statements 2nd 3rd

LIKE clauses

SHOW TABLE statements

FROM clauses 2nd

SHOW TABLE STATUS statements

table storage engines, determining 2ndSHOW TABLES statements

database metadata, accessing 2nd 3rd

LIKE clauses

SHOW VARIABLES statements 2nd 3rd

LIKE clauses 2nd SHOW WARNINGS statements 2nd 3rd 4th 5th query optimization 2nd

SHUTDOWN privileges user account management SIGN() functions 2nd signed hour/minute offset time zones

Skipped field (LOAD DATA INFILE statements) slow logs Slow queries server status variables 2ndslow query logs diagnostic information 2nd 3rd 4th query optimization 2nd SMALLINT integer data types 2nd

AUTO INCREMENT column attributes 2nd

software MySQL software websitesSOME keywords

column comparisons

sort buffer size system variables

sorting

data types 2nd 3rd 4th 5th 6th row query results 2nd 3rd 4th

rows grouped data 2nd

SOURCE command script files, processing source MySQL distributions SPATIAL indexes 2nd specific database privileges

specific stored routine privileges

specific table column privileges

specific table privileges

specifiers (privileges)

splitting

dynamic-length row-storage formatted MyISAM tables 2nd

SQL mode

ERROR FOR DIVISION BY ZERO mode, enabling

Strict mode, enabling

TRADITIONAL mode, enabling 2nd

upgrades

security 2nd 3rd

SQL mode (MySQL Server)

ANSI mode ANSI QUOTES mode

checking

clearing

composiite modes 2nd

ERROR FOR DIVISION BY ZERO mode IGNORE SPACE mode setting

multiple mode names single mode values STRICT ALL TABLES mode 2nd STRICT TRANS TABLES mode 2nd

TRADITIONAL mode SQL mode (MySQL Server), setting 2nd SQL parsers SQL SECURITY DEFINER values (characteristics clauses) 2nd SQL SECURITY INVOKER values (characteristics clauses)SQL statements [See statements] SQLEXCEPTION conditions

SQLWARNING conditions

START SLAVE statements Start/Stop Service tab (MySQL Administrator, Service Control section) 2ndstarting

MySQL Administrator 2nd

starting/stopping

MySQL Server

Unix startup methods 2nd Unix startup prerequisites 2nd 3rd

Windows startup prerequisites 2nd Startup Variables section (MySQL Administrator) 2nd

statement terminators 2nd 3rd 4thstatements canceling in mysql client interactive mode command-line execution

compound statements

defining stored routines 2nd

triggers 2nd

DEALLOCATE PREPARE

prepared statements

error statements

in script files

mysql client interactive mode

EXECUTE

prepared statements 2nd

identifiers

case sensitivity 2nd

function names as

qualified names 2nd reserved words as 2nd 3rd

syntax of 2nd

PREPARE statement 2nd

statements (SQL)

ALTER DATABASE statement 2nd ALTER FUNCTION stored routines

ALTER PROCEDURE stored routines ALTER TABLE 2nd ADD clauses

adding indexes to tables 2nd dropping indexes 2nd ENGINE clauses FIRST keywords MODIFY clauses specifying multiple table alterations ALTER VIEW

ANALYZE TABLE

table maintenance 2nd CALL invoking stored routines

CASE

stored routine conditional testing 2nd

CHANGE MASTER

CHECK TABLE InnoDB table maintenance

table maintenance 2nd comments 2nd

compound in stored routines 2nd CREATE DATABASE statement 2nd CHARACTER SET option COLLATE option

CREATE FUNCTION

characteristics clauses, COMMENT values 2nd

characteristics clauses, DETERMINISTIC values 2nd

characteristics clauses, LANGUAGE SQL values 2nd

characteristics clauses, NOT DETERMINISTIC values 2nd 3rd 4th

characteristics clauses, SQL SECURITY DEFINER values 2nd 3rd 4th

characteristics clauses, SQL SECURITY INVOKER values 2nd

defining stored routines 2nd

routine body clauses 2nd

routine body clauses, RETURNS values 2nd

CREATE INDEX

adding indexes to tables 2nd

CREATE PROCEDURE

defining stored routines 2nd CREATE TABLE

ALTER TABLE option 2nd

AVG ROW LENGTH option 2nd

DATA DIRECTORY option 2nd

ENGINE clauses 2nd ENGINE option IF NOT EXISTS clauses

INDEX clauses INDEX DIRECTORY option 2nd KEY keywords MAX ROWS option 2nd 3rd

PRIMARY KEY keywords 2nd 3rd UNIQUE keywords 2nd 3rd 4th CREATE TABLE LIKE 2nd CREATE TABLE SELECT 2nd 3rd CREATE TEMPORARY TABLE CREATE TRIGGER 2nd CREATE USER 2nd

CREATE VIEW

ALGORITHM clauses 2nd 3rd 4th OR REPLACE clauses 2nd 3rd privilege requirements

syntax of 2nd

WITH CHECK OPTION clauses

DECLARE

stored routines 2nd DECLARE CURSOR

stored routines DECLARE HANDLER 2nd

DELETE emptying tables LIMIT clauses optimization ORDER BY clauses

required privileges

WHERE clauses 2nd

DESCRIBE

accessing database metadata 2nd 3rd

DROP DATABASE statement

IF EXISTS clause

DROP FUNCTION

stored routines

DROP INDEX

DROP PROCEDURE

stored routines

DROP TABLE 2nd

DROP TRIGGER 2nd

DROP USER 2nd DROP VIEW 2nd

privilege requirements

EXECUTE statements

user variables

EXPLAIN join analysis optimization

query analysis usage example 2nd 3rd 4th 5th 6th 7th 8th query analysis, output columns 2nd 3rd 4th 5th 6th 7th FETCH stored routines

FLUSH PRIVILEGES FLUSH STATEMENT GRANT 2nd 3rd IDENTIFIED BY clauses ON clauses 2nd SQL mode upgrades syntax of

TO clauses 2nd

IF stored routine conditional testing INFORMATION SCHEMA TABLES

determining table storage engines

INSERT

data updates 2nd 3rd

NULL values ON DUPLICATE KEY UPDATE clauses 2nd

optimization 2nd records with duplicate key values 2nd

required privileges SET clauses syntax of 2nd tables, adding multiple records to 2nd 3rd VALUES keyword 2nd

ITERATE

stored routine transfer control

LEAVE

stored routine transfer control

LOAD DATA INFILE 2nd

data file format specifiers 2nd 3rd 4th

Deleted field

duplicate table records 2nd

efficiency of

FIELDS clauses

LINES clauses 2nd

loading specific table columns 2nd

NULL values 2nd

privilege requirements Records field

Skipped field

skipping data file lines

skipping table column values

specifying data file locations 2nd 3rd syntax of transforming table column values 2nd

Warnings field LOCK TABLES 2nd LOW PRIORITY WRITE option READ LOCAL option

READ option 2nd WRITE option LOOP stored routine loops 2nd OPTIMIZE TABLE table maintenance 2nd prepared statements

benefits of

creating 2nd deallocating executing 2nd

mysql client usage example 2nd

privilege checks (client access control)

RENAME TABLE

RENAME USER 2nd REPAIR TABLE

table maintenance 2nd REPEAT

stored routine loops 2nd REPLACE 2nd 3rd 4th optimization required privileges RETURN

stored routine transfer control

REVOKE 2nd 3rd 4th

SELECT

AVG() aggregate functions 2nd

column aliases 2nd

COUNT() aggregate functions 2nd 3rd

data retrieval 2nd

data retrieval, aggregating results 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th

data retrieval, column retrieval 2nd 3rd 4th 5th

data retrieval, concatenating row results 2nd 3rd

data retrieval, grouping results 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th

data retrieval, row retrieval 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th

DISTINCT clauses 2nd 3rd 4th

FOR UPDATE modifiers FROM clauses, subqueries 2nd

GROUP BY clauses 2nd 3rd 4th 5th

GROUP CONCAT() aggregate functions 2nd 3rd 4th

GROUP CONCAT() functions 2nd 3rd

HAVING clauses 2nd 3rd HIGH PRIORITY clauses joins 2nd

LIMIT clauses 2nd 3rd LOCK IN SHARE MODE modifiers 2nd MAX() aggregate functions 2nd 3rd MIN() aggregate functions 2nd 3rd

ORDER BY clauses 2nd 3rd 4th 5th 6th SUM() aggregate functions 2nd syntax of UNION keyword 2nd 3rd WHERE clauses 2nd SELECT INTO assigning variable values in stored routines

SELECT INTO OUTFILE 2nd 3rd

binary backups 2nd data file format specifiers 2nd 3rd 4th FIELDS clauses

LINES clauses 2nd

NULL values 2nd

SELECT statements

user variables SET

assigning variable values in stored routines 2nd SET PASSWORD 2nd 3rd

SET statements user variables 2nd SET TRANSACTION ISOLATION LEVEL SHOW versus INFORMATION SCHEMA database 2nd

SHOW CHARACTER SET 2nd

SHOW COLLATION 2nd

SHOW COLUMNS

accessing database metadata 2nd 3rd 4th

LIKE clauses

SHOW CREATE DATABASE statement

SHOW CREATE FUNCTION

displaying stored function metadata

SHOW CREATE PROCEDURE

displaying stored procedure metadata

SHOW CREATE TABLE 2nd

determining table storage engines 2nd

KEY clauses

SHOW CREATE VIEW privilege requirements

SHOW DATABASES

accessing database metadata 2nd 3rd

LIKE clauses

SHOW DATABASES statement 2nd LIKE clauses SHOW ENGINEINNODB STATUS 2nd

SHOW ENGINES 2nd 3rd SHOW ERRORS 2nd SHOW FIELDS accessing database metadata

SHOW FULL TABLES 2nd SHOW FUNCTION STATUS displaying stored function metadata SHOW GRANTS 2nd 3rd SHOW INDEX accessing database metadata SHOW KEYS

accessing database metadata

SHOW MASTER STATUS SHOW PROCEDURE STATUS displaying stored procedure metadata

SHOW PROCESSLIST 2nd

query optimization

viewing replication threads 2nd

SHOW SLAVE HOSTS SHOW SLAVE STATUS 2nd

SHOW STATUS 2nd 3rd LIKE clauses

SHOW TABLE FROM clauses 2nd SHOW TABLE STATUS determining table storage engines 2nd SHOW TABLES

accessing database metadata 2nd 3rd

LIKE clauses

SHOW VARIABLES 2nd 3rd

LIKE clauses 2nd

SHOW WARNINGS 2nd 3rd 4th 5th

query optimization 2nd

START SLAVE

stored routines

TRUNCATE TABLE 2nd

emptying tables

required privileges

UNLOCK TABLES

UPDATE 2nd

LIMIT clauses 2nd optimization

ORDER BY clauses

required privileges

SET clauses 2nd

WHERE clauses 2nd 3rd 4th WITHC CHECK OPTION clauses 2nd 3rd USE

selecting/changing default databases user accounts, modifying WHILE stored routine loops 2nd 3rd

STATUS command information display example 2ndstatus files backups MySQL Server MySQL Server storagestatus variables (MySQL server)

Key read requests

Key reads Opened tables Qcache hits

Qcache inserts

Qcache lowmem prunes

Qcache queries in cache

Threads connectedstopping/starting

MySQL Server Unix startup methods 2nd

Unix startup prerequisites 2nd 3rd Windows startup prerequisites 2nd storage engine tiers (mysql client/server architecture) 2ndstorage engines ARCHIVE

BDB

BLACKHOLE

compiling

CSV

data/index files

MySQL Server storage

EXAMPLE

FEDERATED 2nd

operational characteristics

InnoDB

--skip-innodb option

--without-innodb option

ACID compliance 2nd

buffer pool configurations dirty reads

disabling

disabling autocommit mode 2nd 3rd

foreign keys 2nd 3rd 4th 5th

implicitly ending transactions innodb buffer pool size option innodb data file path option

innodb data home dir option 2nd innodb flush log at trx commit option 2nd innodb log buffer size option innodb log file size option

innodb log files in group option isolation levels, setting at server startup 2nd 3rd locking characteristics 2nd 3rd log file configurations 2nd 3rd log files nonrepeatable reads operational characteristics 2nd

phantoms 2nd

READ COMMITTED isolation levels 2nd 3rd READ UNCOMMITTED isolation levels 2nd REPEATABLE READ isolation levels 2nd 3rd

SERIALIZABLE isolation levels 2nd

setting transaction savepoints

shared tablespace configurations 2nd 3rd 4th 5th

shared tablespaces 2nd SHOW ENGINEINNODB STATUS statements 2nd

SHOW TABLE STATUS statements storing log buffers in MySQL Server

table management table optimization 2nd 3rd tablespace/log file storage in MySQL Server transaction effects on explicit table locks transactional model 2nd 3rd 4th

viewing status information 2nd

ISAM

management

MEMORY

BTREE indexes

hash indexes

operational characteristics

storing tables in MySQL Server

table management

table optimization

memory usage

MERGE

disadvantages of

locking characteristics operational characteristics

table optimization 2nd

MyISAM

AUTO INCREMENT numeric column attribute 2nd

locking characteristics 2nd 3rd 4th operational characteristics 2nd row-storage formats 2nd

row-stroage formats, converting row-stroage formats, explicitly specifying for new tables table management table optimization 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th

MySQL Server optimization NDBCluster benefits of 2nd operational characterisitics 2nd optional engines server availability, viewing 2nd SHOW ENGINES statements 2nd

table management 2nd

tables creating MEMORY tables creating TEMPORARY tables 2nd

determining in 2nd

optimizing, general design principles 2nd

optimizing, PROCEDURE ANALYSE() 2nd 3rd

specifying in tables, specifying for 2nd

storage engines (queries) 2nd 3rd stored functions [See also stored routines]

ALTER FUNCTION statements DROP FUNCTION statements invoking metadata, displaying SHOW CREATE FUNCTION statements

SHOW FUNCTION STATUS statements

parameters

syntax of

versus stored procedures

stored procedures [See also stored routines]

ALTER PROCEDURE statements

DROP PROCEDURE statements

invoking

CALL statements

metadata, displaying

SHOW CREATE PROCEDURE statements

SHOW PROCEDURE STATUS statements

multiple result sets, retrieving parameters

INOUT

OUT 2nd

syntax of versus stored functionsstored routines

access privileges ALTER FUNCTION statements ALTER PROCEDURE statements application performance, enhancing 2nd

benefits of 2nd compound statements conditional testing CASE statements 2nd IF statements database administration security 2nd DEFINER security characterisitic 2nd

EXECUTE privilege characteristic

defining 2nd compound statements 2nd 3rd 4th conditions 2nd

CREATE FUNCTION statements 2nd 3rd 4th 5th 6th

CREATE PROCEDURE statements 2nd 3rd 4th 5th 6th

cursors 2nd

DECLARE statements 2nd declaring parameters 2nd 3rd

flow control 2nd handlers 2nd 3rd

SELECT INTO statements SET statements 2nd variables 2nd 3rd 4th DROP FUNCTION statements DROP PROCEDURE statements

functions

versus procedures

invoking

CALL statements

loops

LOOP statement 2nd

REPEAT statement 2nd

WHILE statement 2nd 3rd

managing

in MySQL Query Browser 2nd

metadata, displaying

ROUTINES table (INFORMATION SCHEMA database) 2nd

namespaces 2nd

privileges 2nd qualified names

identifiers (SQL statements)

specific privileges

transfer control

ITERATE statement LEAVE statement RETURN statement

storing database directories in MySQL Server frm files

in MySQL Server 2nd InnoDB storage engine tablespaces/log files in MySQL Server server log files in MySQL Server status files in MySQL Server

storage engine data/index files

in MySQL Server temporary files performance optimization strategies

STRCMP() functions

STRICT ALL TABLES mode (SQL mode) 2nd

STRICT ALL TABLES SQL mode 2nd

Strict mode (SQL mode), enabling STRICT TRANS TABLES mode (SQL mode) 2nd

STRICT TRANS TABLES SQL mode 2ndstring column attributes

BINARY 2nd CHARACTER SET 2nd COLLATE 2ndstring data types BINARY 2nd 3rd

binary string data types 2nd

characteristics of 2nd

string column atttributes 2nd

versus nonbinary data types 2nd

BLOB 2nd 3rd

CHAR 2nd 3rd

ENUM 2nd 3rd 4th 5th

LONGBLOB

LONGTEXT

MEDIUMBLOB

MEDIUMTEXT

nonbinary string data types 2nd 3rd

characteristics of 2nd

string column atttributes 2nd versus binary data types 2nd

overview of

SET 2nd 3rd 4th

TEXT 2nd 3rd 4th

TINYBLOB TINYTEXT VARBINARY 2nd 3rd

VARCHAR 2nd 3rd 4th string expressions 2nd case sensitivity 2nd binary strings 2nd 3rd 4th 5th

literal strings nonbinary strings pattern-matching 2nd 3rd 4th 5th 6thsubqueries column subqueries converting to inner joins 2nd 3rd

to outer joins 2nd

correlated subqueries FROM clauses 2nd noncorrelated subqueries 2nd

row subqueries

row comparisons 2nd 3rd

scalar subqueries 2nd

column comparisons 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th CONCAT() functions

table subqueries updates 2nd

usage examples WHERE clauses converting subqueries to inner joins updatesSUM() aggregate functions

SELECT statements 2nd

summarizing

row data retrievals 2nd

COUNT() aggregate functions 2nd 3rd

GROUP CONCAT() aggregate functions 2nd 3rd 4th

MIN()/MAX() aggregate functions 2nd

SUM()/AVG() aggregate functions 2nd

summary tables

query optimization 2nd 3rd 4th

SUPER privilege

trigger creation/deleting

SUPER privileges

user account management

symbolic links databases, moving 2nd

symlinking

tables

syntax

INSERT statements 2nd SELECT statements stored functions

stored procedures syntax browser (MySQL Query Browser, Information Browser) SYSTEM time zones System Tray monitor (MySQL Administrator)

system values (type output columns)system variables (MySQL server) innodb buffer pool size innodb log buffer size join buffer size key buffer size 2nd max connections

query cache limit

query cache min res unit query cache size query cache type 2nd 3rd

query cache wlock invalidate

read buffer size

sort buffer size

table cache

Index

Категории