MySQL Cookbook

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] [X] [Y]

-A (skip-auto-rehash) option

<a> HTML anchor tag

a( ) function (Perl)

absolute values in rows 2nd

abstractions

Access (Microsoft)

access counting

"access denied" message

access logging

access privileges, setting library files

accounts

action elements (JSP)

--add-databases option

--add-drop-table option

affectedRows( ) method (PHP) 2nd

AFTER INSERT trigger

AGAINST( ) function

aggregate functions

     handling NULL values

aliases (column) 2nd

align attribute (<td> HTML tag)

ALTER TABLE statement 2nd 3rd

     eliminating duplicates from tables

     ENUM/SET columns definitions, adding elements

     resequencing columns

     reusing values at top of sequence

     storage engines, checking or changing

     transactional storage engines and

ambiguous column names

ambiguous table names

ampersand (&), in HTML entities

ANSI_QUOTES SQL mode

     string literals and

Apache web server 2nd

     logging

Apache::Session module (Perl) 2nd

API (application programming interface) 2nd

     library files, installing

     result set metadata, obtaining

     special characters and

     special characters and NULL values

     statements, sending

     transactions and

application object (JSP)

application programming interface [See API]

application scope (JSP)

arbitrary column delimiters in output

@ARGV array

ARGV array (Ruby)

arrays

     query( ) method and

     rows, fetching

ASCII NUL (\0)

assigning ranks

asterisk (*)

     COUNT( ) function, summarizing with

     FULLTEXT searches and

     pattern matching

     Perl pattern matches and

     SELECT statements, using in

at sign (@)

     matching email addresses

     user-defined variables and

attributes (HTML/XML/XHTML)

auto-commit mode

     Perl DBI transaction

auto-completion

AUTO__INCREMENT values

     extending ranges of sequence columns

AUTO_INCREMENT values 2nd

     creating multiple sequences

     data types, choosing for

     generating columns/values and

     managing multiple simultaneous values

     relating tables with

     resequencing columns

     retrieving sequence values and

     row deletions, effects of

     sequence generators as counters

     stating sequences at particular values

     unsequenced tables

AutoCommit attribute (Perl) 2nd

autoCommit( ) method (PHP)

auxiliary tables

average set of values

AVG( ) function 2nd

     IFNULL( ) function and

     subgroups, dividing into

     summarizing with

AxKit