MySQL in a Nutshell, 2nd Edition

Index

A note on the digital index

A link in an index entry is displayed as the section title in which that entry appears. Because some sections have multiple index markers, it is not unusual for an entry to have several links to the same section. Clicking on any link will take you directly to the place in the text in which the marker appears.

Symbols

% (percent sign) wildcard, Searching Data

* (asterisk) wildcard, ,

; (semicolon), ending SQL statements,

= (equal) operator, using with subquery in a WHERE clause, Single Field Subqueries

\G (G flag), for long layout, ,

A

ABS function,

ACOS function,

ADD COLUMN clause, ALTER TABLE statement, ALTER TABLE: ADD clauses for columns

ADD PARTITION clause, ALTER TABLE, ALTER TABLE: Partition altering clauses

ADDDATE function,

ADDTIME function,

Advanced Encryption Standard (AES) algorithm,

AES_DECRYPT function,

AES_ENCRYPT function,

AFTER INSERT triggers,

AFTER keyword, ALTER TABLE: CHANGE clauses

aggregate functions, Aggregate Functions in Alphabetical Order–

AVG,

BIT_AND,

BIT_OR,

BIT_XOR,

COUNT,

general characteristics of, Aggregate Functions in Alphabetical Order

GROUP_CONCAT,

HAVING clause in SELECT statment, Having SELECT results

MAX,

MIN,

STD,

STDDEV,

STDDEV_POP,

STDDEV_SAMP,

SUM,

VARIANCE,

VAR_POP,

VAR_SAMP,

ALGORITHM parameter, CREATE VIEW statement,

aliases, creating, Selecting Data

ALL operator, Multiple Fields Subqueries

ALL option, REVOKE statement,

ALTER DATABASE statement,

ALTER EVENT statement, Statements in Alphabetical Order

ALTER FUNCTION ...