MySQL in a Nutshell

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) (see percent sign)

& (ampersand), Unix Source Distributions

( ) parentheses, Changing Data, INSERT, Multiple-row insertions

, (comma) (see comma)

\\\\ (backslash), Unix Source Distributions, Exporting SELECT results, QUOTE( )

A

ABS( ) function, ABS( )

ACOS( ) function, ACOS( )

ActivePerl, The MySQL Package

ADD clause (ALTER TABLE), ADD clauses for columns and indexes, ADD clauses for foreign keys

ADD COLUMN clause (ALTER TABLE), ADD clauses for columns and indexes

ADD INDEX clause (ALTER TABLE), ADD clauses for columns and indexes

--add-drop-table option (mysqldump), mysqldump

--add-locks option (mysqldump), mysqldump

ADDDATE( ) function, ADDDATE( ), DATE_ADD( ), SUBDATE( )

ADDTIME( ) function, ADDTIME( ), SUBTIME( )

AES algorithm, AES_DECRYPT( )

AES_DECRYPT( ) function, AES_DECRYPT( ), AES_ENCRYPT( )

AES_ENCRYPT( ) function, AES_DECRYPT( ), AES_ENCRYPT( )

AFTER keyword

ADD COLUMN clause, ADD clauses for columns and indexes

CHANGE COLUMN clause, CHANGE clauses

aggregate functions, Mathematical and Aggregate Functions–VARIANCE( )

aliases

AS keyword and, Selecting Data, Selecting Data, Selecting Data, Table flags and indexing options, LOCK TABLES ...