Index A

[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] [Z]

a()
    hyperlink generation 
ABS() function 
absolute updates
    versus relative updates  2nd 
Access
    MySQL server connections 
access control
    to data directory  2nd  3rd  4th 
access control.  [See security]
accessing
    tables  2nd 
accessor macros
    C API  2nd 
account
    login accounts.  [See login accounts]
accounts
    anonymous 
        avoiding 
        deleting 
        passwords, setting 
        privileges of 
    creating  2nd 
    deleting 
    for master-slave replication relationship 
    GRANT statement
        operational overview  2nd 
    passwords
        changing  2nd 
    privileges
        granting  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th 
        revoking  2nd 
        types of  2nd  3rd  4th 
    root 
        passwords, setting  2nd  3rd 
        security implications in Windows 
        warning against running server as 
    unprivileged login account
        starting server as  2nd 
accounts.  [See user accounts]
ACID (Atomic, Consistent, Isolated, Durable) 
ACOS() function 
ADD COLUMN clause
    altering tables 
ADD FOREIGN KEY clause
    altering tables 
ADD FULLTEXT clause
    altering tables 
ADD INDEX clause
    altering tables 
ADD PRIMARY KEY clause
    altering tables 
ADD UNIQUE clause
    altering tables 
ADDDATE() function 
addition operator (+)  2nd 
additional servers.  [See multiple servers]
addslashes()
    escaping quotation marks in PHP 
administration
    database repair and maintenance  2nd 
    duties of  2nd  3rd  4th  5th  6th 
    security  2nd 
administrative functions
    C API 
administrative methods
    Perl DBI API  2nd  3rd 
administrative optimization  2nd  3rd 
    hardware configuration  2nd 
    query cache  2nd 
administrative privileges (grant tables)
    list of  2nd  3rd 
AES_DECRYPT() function 
AES_ENCRYPT() function 
AGAINST()
    full text searches 
AGAINST() function  2nd  3rd 
age
    expiration of log files by  2nd 
aggregate functions.  [See summary functions]
AGGREGATE keyword
    creating functions 
aliases
    case sensitivity 
    column aliases 
    for backward-compatibility
        PHP functions 
    naming conventions 
    server connections via  2nd 
    table aliases 
ALL keyword
    joining SELECT statements together 
    retrieving rows from tables 
    unions 
ALL privilege  2nd 
ALL PRIVILEGES privilege 
ALTER COLUMN clause
    altering tables 
ALTER DATABASE statement  2nd  3rd  4th 
ALTER privilege  2nd  3rd 
    avoiding risks 
ALTER TABLE statement  2nd  3rd  4th  5th  6th  7th  8th  9th 
    converting tables to MyISAM 
    converting tables to MySQL 4.1 
    creating indexes  2nd  3rd 
    dropping indexes  2nd 
    when not to use  2nd 
altering
    databases  2nd  3rd  4th 
    tables  2nd  3rd  4th  5th  6th  7th  8th 
ampersand (&)
    bitwise AND operator 
ANALYZE TABLE statement  2nd 
    query optimization 
analyzing
    tables  2nd 
AND bitwise operator (&) 
AND logical operator (&&)  2nd 
anonymous accounts 
    avoiding 
    deleting 
    passwords, setting 
    privileges of 
ansi_mode variable 
Apache
    installation on UNIX  2nd  3rd 
    installation on Windows 
    obtaining for installation  2nd  3rd 
    setup for CGI scripts  2nd  3rd 
APIs
    (application programming interfaces)  2nd  3rd 
    C API  2nd  3rd  4th  5th  6th 
        administrative functions 
        compiling  2nd 
        compiling and linking client programs  2nd  3rd 
        connection management functions  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th 
        data types 
        debugging functions  2nd 
        deprecated functions  2nd  3rd  4th  5th  6th  7th  8th 
        embedded server applications  2nd  3rd  4th  5th  6th  7th 
        embedded server communication functions  2nd 
        error checking  2nd  3rd  4th  5th 
        error handling functions  2nd 
        example client programs 
        functions  2nd 
        history of 
        information gathering functions  2nd  3rd  4th 
        linking  2nd 
        macros  2nd 
        mysql_config utility  2nd 
        non-scalar data types  2nd  3rd  4th  5th  6th  7th  8th 
        option files  2nd 
        processing command-line arguments  2nd  3rd  4th  5th  6th  7th  8th  9th 
        query functions  2nd  3rd  4th  5th 
        query handling  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th  18th  19th  20th  21st  22nd  23rd  24th  25th  26th  27th  28th  29th  30th  31st 
        reading option files  2nd  3rd  4th 
        result set processing functions  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th 
        scalar data types  2nd 
        server connections  2nd  3rd 
        server connections with connection parameters  2nd  3rd  4th 
        SSL support  2nd  3rd  4th 
        system requirements  2nd 
        threaded client functions  2nd 
        troubleshooting  2nd  3rd  4th  5th  6th  7th 
    Perl DBI API  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
        administrative methods  2nd  3rd 
        attributes  2nd 
        class methods  2nd  3rd  4th  5th  6th  7th  8th  9th 
        connection parameters  2nd  3rd  4th  5th  6th 
        database handle attributes  2nd  3rd  4th  5th 
        database handle methods  2nd  3rd  4th  5th  6th  7th  8th  9th 
        debugging  2nd  3rd  4th  5th  6th  7th  8th 
        directory listing example  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
        dynamic attributes  2nd 
        environment variables 
        error handling  2nd  3rd  4th  5th  6th 
        escaping quotation marks  2nd  3rd  4th  5th 
        general handle attributes  2nd  3rd 
        general handle methods  2nd 
        handles  2nd 
        HTML document example  2nd  3rd  4th  5th 
        member common interests example  2nd 
        member entry editing example  2nd  3rd  4th  5th  6th  7th 
        membership renewal example  2nd  3rd  4th  5th  6th  7th  8th 
        methods  2nd  3rd 
        operational overview  2nd  3rd  4th  5th  6th  7th  8th  9th 
        parameter binding  2nd 
        placeholders  2nd  3rd  4th  5th  6th 
        predecessor of 
        query result processing  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th 
        requirements 
        result set metadata  2nd  3rd  4th  5th  6th 
        running scripts  2nd 
        statement handle attributes  2nd  3rd  4th  5th  6th  7th  8th 
        statement handle methods  2nd  3rd  4th  5th  6th  7th 
        testing for NULL values  2nd 
        transactions  2nd  3rd  4th 
        utility functions  2nd 
        variables 
        Web-based applications  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th  18th  19th  20th  21st  22nd  23rd  24th  25th  26th  27th  28th  29th  30th  31st  32nd  33rd  34th  35th  36th  37th  38th  39th  40th  41st  42nd  43rd  44th  45th  46th  47th 
    PHP API  2nd  3rd  4th  5th  6th  7th  8th 
        connection management functions  2nd  3rd  4th  5th  6th 
        data retrieval example  2nd  3rd  4th 
        deprecated functions  2nd 
        error handling  2nd  3rd  4th  5th  6th 
        error handling functions  2nd  3rd 
        escaping quotation marks  2nd  3rd 
        file extensions 
        function parameters  2nd 
        include files  2nd  3rd  4th  5th  6th  7th  8th 
        information gathering functions  2nd  3rd 
        input parameters  2nd  3rd  4th  5th  6th 
        member entry editing example  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th 
        opening and closing tags  2nd  3rd 
        operational overview  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
        predecessor of 
        president quiz example  2nd  3rd  4th  5th  6th 
        query functions  2nd  3rd  4th  5th  6th  7th  8th  9th 
        query result processing  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th 
        result set processing functions  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th  18th  19th  20th  21st 
        standalone scripts  2nd 
        student scores example  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th 
        syntax similarities with other languages 
        testing for NULL values  2nd 
        variables  2nd 
    selection criteria  2nd 
        development time  2nd  3rd  4th 
        execution environment  2nd 
        performance  2nd  3rd  4th  5th  6th  7th  8th 
        portability  2nd 
application programming interfaces.  [See APIs]
APs
    C API 
apxs Apache Extension Tool 
arithmetic operators  2nd  3rd  4th  5th  6th 
    type conversion 
arrays
    C API.  [See also non-scalar data types]
AS clause
    column aliases 
AS keyword
    retrieving rows from tables 
ASCII() function 
    forcing type conversion 
ASIN() function 
asterisk (*)
    multiplication operator 
ATAN() function 
ATAN2() function 
atomicity (transactions) 
attributes
    column types  2nd 
    date and time column types  2nd 
    numeric types  2nd  3rd 
    Perl DBI API  2nd 
        database handle attributes  2nd  3rd  4th  5th 
        dynamic attributes  2nd 
        general handle attributes  2nd  3rd 
        statement handle attributes  2nd  3rd  4th  5th  6th  7th  8th 
    string types  2nd  3rd  4th 
authentication
    PHP API  2nd  3rd  4th  5th  6th  7th 
AUTO INCREMENT keyword
    creating tables 
AUTO INCREMENT option
    creating tables 
auto-commit mode
    setting 
auto-extending InnoDB tablespace files 
auto-recovery capabilities of server  2nd 
AUTO_INCREMENT attribute  2nd 
    adding to tables  2nd 
    BDB tables 
    forcing non-reuse of numbers 
    HEAP tables 
    InnoDB tables 
    ISAM tables  2nd  3rd 
    MyISAM tables  2nd  3rd  4th 
    numeric column types  2nd 
    resequencing columns  2nd 
    selecting column types 
    tips for  2nd  3rd 
AUTO_INCREMENT columns  2nd 
AutoCommit attribute
    Perl DBI API 
AUTOCOMMIT option
    setting variables 
automatic type conversion
    query optimization 
available_drivers()
    Perl DBI class method 
AVG ROW LENGTH option
    creating tables 
AVG() function 
    generating summaries