Index C

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

C API  2nd  3rd  4th  5th  6th  7th 
    client programs
        compiling and linking  2nd  3rd 
        error checking  2nd  3rd  4th  5th 
        option files  2nd 
        processing command-line arguments  2nd  3rd  4th  5th  6th  7th  8th  9th 
        reading option files  2nd  3rd  4th 
        server connections  2nd  3rd 
    compiling  2nd 
    data types 
        non-scalar  2nd  3rd  4th  5th  6th  7th  8th 
        scalar  2nd 
    embedded server applications  2nd  3rd  4th  5th 
        executable binary for  2nd 
    example client programs 
    external support 
    functions
        administrative 
        checking return values  2nd 
        connection management  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th 
        debugging  2nd 
        deprecated  2nd  3rd  4th  5th  6th  7th  8th 
        embedded server communication  2nd 
        error handling  2nd 
        information gathering  2nd  3rd  4th 
        parameters  2nd 
        queries  2nd  3rd  4th  5th 
        result set processing  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th 
        threaded client  2nd 
    header files  2nd 
    history of 
    libraries  2nd 
    linking  2nd 
    macros  2nd 
    memory management 
    mysql_config utility  2nd 
    portability 
    query handling  2nd 
        calculations on result sets  2nd 
        escape characters  2nd  3rd 
        general purpose example  2nd  3rd 
        image data  2nd 
        interactive query program example  2nd 
        mysql_store_result() versus mysql_use_result()  2nd  3rd 
        process_query() alternatives  2nd 
        result set metadata  2nd  3rd  4th  5th 
        table information 
        with result set  2nd  3rd  4th 
        without result set  2nd 
    server connections
        with connection parameters  2nd  3rd  4th 
    SSL support  2nd  3rd  4th 
    system requirements  2nd 
    text manipulation 
    troubleshooting
        function return values  2nd 
        NULL column values  2nd 
        uninitialized connection handler pointers  2nd 
        uninitialized result buffer pointers 
C-style comments  2nd  3rd  4th 
CA (Certificate Authority) certificates 
cache
    resetting  2nd 
cache size
    query optimization  2nd  3rd  4th 
caches
    flushing  2nd 
caching queries 
calculating
    columns with expressions  2nd 
calculations
    on result sets  2nd 
canceling
    queries 
caret (^)
    bitwise XOR operator 
cartesian products 
CASCADE keyword
    dropping tables 
cascaded deletes 
CASE comparison operator  2nd 
case sensitivity
    character sets 
    data directory filenames  2nd 
    database and table names 
    grant table scope columns 
    selecting column types  2nd 
    SQL statement naming conventions  2nd 
cast functions  2nd 
cast operators  2nd 
CAST() function  2nd  3rd 
CEILING() function 
CERATE TEMPORARY TABLES privilege 
Certificate Authority (CA) certificates 
certificate files 
certificates
    X509 certificates
        requiring 
CGI scripts
    Apache Web server setup  2nd  3rd 
    installing 
CGI.pm Perl module  2nd  3rd  4th 
    escaping HTML and URL text  2nd 
    input parameters  2nd 
    invoking scripts with parameters  2nd  3rd  4th  5th  6th 
    writing Web output  2nd  3rd  4th 
CHANGE clause
    ALTER TABLE statement  2nd 
CHANGE COLUMN clause
    altering tables 
CHANGE MASTER statement  2nd  3rd 
CHANGED option
    error checking tables  2nd 
CHAR columns.  [See fixed-length columns]
CHAR string type  2nd  3rd  4th  5th  6th  7th 
CHAR() function 
    forcing type conversion 
CHAR_LENGTH() function 
character data types.  [See string data types]
CHARACTER SET option
    creating tables 
    setting variables 
character sets  2nd 
    case sensitivity 
    configuring support for  2nd 
        converting tables to MySQL 4.1  2nd 
    converting tables to MySQL 4.1 
    default character set
        setting 
    determining usage  2nd 
    displaying supported  2nd 
    setting default 
    setting for columns 
    specifying  2nd  3rd 
    support after MySQL 4.1  2nd 
    support prior to MySQL 4.1  2nd 
    Unicode support  2nd 
CHARACTER_LENGTH() function 
CHARACTER_SET attribute
    specifying character sets  2nd 
    string column types  2nd  3rd  4th 
character_set variable 
character_sets variable 
characters
    versus bytes (string length)  2nd 
CHARSET() function 
CHECK clause
    creating tables 
CHECK TABLE statement  2nd  3rd  4th  5th 
CHECKSUM option
    creating tables 
choosing.  [See selecting]2nd  [See selecting]3rd  [See selection criteria]
ChopBlanks attribute
    Perl DBI API 
CIPHER keyword
    granting privileges 
CIPHER option
    granting privileges 
class methods
    Perl DBI API  2nd  3rd  4th  5th  6th  7th  8th  9th 
clear command 
client access software
    selecting ISPs 
client libraries.  [See APIs]
client library.  [See C API]
client programs
    command-line arguments
        processing  2nd  3rd  4th  5th  6th  7th  8th  9th 
    compiling and linking  2nd  3rd 
    error checking  2nd  3rd  4th  5th 
    examples
        obtaining 
    option files  2nd 
        reading  2nd  3rd  4th 
    query handling  2nd 
        calculations on result sets  2nd 
        escape characters  2nd  3rd 
        general purpose example  2nd  3rd 
        image data  2nd 
        interactive query program example  2nd 
        mysql_store_result() versus mysql_use_result()  2nd  3rd 
        process_query() alternatives  2nd 
        result set metadata  2nd  3rd  4th  5th 
        table information 
        with result set  2nd  3rd  4th 
        without result set  2nd 
    server connections  2nd  3rd 
        with connection parameters  2nd  3rd  4th 
    SSL support  2nd  3rd  4th 
    system requirements  2nd 
    troubleshooting
        function return values  2nd 
        NULL column values  2nd 
        uninitialized connection handler pointers  2nd 
        uninitialized result buffer pointers 
client programs.  [See programming MySQL]
client software
    reasons for installing  2nd 
client/server architecture
    access control to data directory  2nd  3rd  4th 
client/server architecture of MySQL  2nd  3rd 
clients 
    mysql 
    mysqladmin 
    mysqldump 
closing tags
    PHP API  2nd  3rd 
    PHP scripts 
COALESCE() function 
COLLATE cast operator 
COLLATE operator 
column aliases  2nd 
column declarations  2nd 
column names
    in expressions  2nd 
column types  2nd  3rd  4th  5th  6th  7th  8th 
    attributes  2nd 
    creating tables  2nd  3rd 
    date and time types  2nd  3rd  4th  5th  6th 
        attributes  2nd 
        DATE type  2nd  3rd 
        DATETIME type  2nd  3rd 
        input formats for  2nd  3rd 
        ranges for 
        storage requirements 
        TIME type  2nd  3rd  4th 
        TIMESTAMP type  2nd  3rd  4th  5th  6th 
        YEAR type  2nd  3rd 
        year value interpretations  2nd  3rd 
        zero values 
    displaying information about  2nd 
    numeric types  2nd  3rd  4th  5th  6th  7th 
        attributes  2nd  3rd 
        BIGINT  2nd 
        DECIMAL  2nd  3rd  4th  5th  6th  7th 
        DOUBLE  2nd  3rd 
        FLOAT  2nd  3rd 
        floating-point numbers  2nd  3rd  4th  5th  6th 
        INT  2nd 
        integers  2nd  3rd  4th 
        MEDIUMINT  2nd 
        ranges for 
        selecting  2nd  3rd 
        SMALLINT  2nd 
        storage requirements 
        TINYINT  2nd 
    query optimization  2nd  3rd 
    selecting  2nd  3rd  4th 
        AUTO_INCREMENT columns 
        case sensitivity  2nd 
        indexes  2nd 
        performance issues  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
        range of values in column  2nd  3rd 
        types of values in column  2nd  3rd  4th  5th 
    string types  2nd  3rd  4th  5th  6th  7th  8th 
        attributes  2nd  3rd  4th 
        BLOB string type  2nd  3rd 
        CHAR string type  2nd  3rd  4th  5th  6th  7th 
        ENUM string type  2nd  3rd  4th  5th  6th  7th  8th  9th 
        length in characters versus bytes  2nd 
        LONGBLOB string type  2nd 
        LONGTEXT string type  2nd 
        MEDIUMBLOB string type  2nd 
        MEDIUMTEXT string type  2nd 
        SET string type  2nd  3rd  4th  5th  6th  7th  8th  9th 
        size and storage requirements 
        TEXT string type  2nd  3rd 
        TINYBLOB string type  2nd 
        TINYTEXT string type  2nd 
        VARCHAR string type  2nd  3rd  4th  5th  6th  7th 
    versus data types 
column-level privileges
    granting  2nd 
Column_name column (grant tables) 
columns
    calculating with expressions  2nd 
    case sensitivity 
    changing type of  2nd 
    comparisons
        importance of column type 
        on indexed columns  2nd 
    displaying  2nd 
    naming conventions 
    qualifying references to 
    selecting for indexes  2nd 
columns_priv table (in grant table) 
command history list
    server connections via  2nd 
command-line
    starting servers 
command-line arguments
    passwords as 
    processing  2nd  3rd  4th  5th  6th  7th  8th  9th 
commands
    mysql program  2nd  3rd 
    mysql program history file  2nd 
    mysqladmin utility  2nd  3rd 
    perldoc 
COMMENT keyword
    creating tables 
COMMENT option
    creating tables 
comment styles  2nd  3rd  4th 
    lacking support 
comments
    in PHP API 
    Perl DBI API 
COMMIT statement  2nd  3rd  4th  5th  6th 
commit()
    Perl DBI database handle method 
    Perl DBI transactions 
committing
    transactions  2nd 
comparison functions  2nd  3rd  4th 
comparison operators  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
    type conversion  2nd 
comparisons
    importance of column type 
    on indexed columns  2nd 
compiled languages
    versus interpreted languages  2nd 
compilers
    for client programs 
compiling
    C API  2nd 
    client programs  2nd  3rd 
composite indexes  2nd 
compressing
    dump files 
CONCAT() function 
    forcing type conversion 
    type conversion 
CONCAT_WS() function 
concatenation (strings)  2nd 
concurrency
    query optimization  2nd 
concurrency.  [See transactions]
CONCURRENT clause
    loading data 
concurrent inserts 
concurrent_insert variable 
configure utility (UNIX)  2nd 
    clearing stored information 
configuring
    multiple servers  2nd 
configuring servers
    administration duties 
connect command 
connect()
    Perl DBI class method  2nd  3rd  4th  5th  6th  7th 
    Perl DBI connections  2nd 
    Perl DBI error handling  2nd 
connect_cached()
    Perl DBI class method  2nd 
connect_timeout variable  2nd 
connection identifiers
    PHP API  2nd 
connection management functions
    C API  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th 
    PHP API  2nd  3rd  4th  5th  6th 
connection parameters
    command-line arguments for
        processing  2nd  3rd  4th  5th  6th  7th  8th  9th 
    in client programs  2nd  3rd  4th 
    option files for  2nd 
        reading  2nd  3rd  4th 
    Perl DBI API  2nd  3rd  4th  5th  6th 
CONNECTION_ID() function 
connections 
    ***same as network connections*** 
    creating accounts for  2nd 
    listening for  2nd 
    localhost  2nd 
    securing.  [See also external security]
    SSL  2nd  3rd  4th 
    SSL connections
        specifying in GRANT statement  2nd 
    TCP/IP connections
        establishing 
    terminating 
    via mysql command  2nd  3rd  4th 
    via option files  2nd 
    via shell aliases  2nd 
    via shell history list  2nd 
connections to server.  [See server connections]
connections.  [See server connections]
connectivity options
    selecting ISPs  2nd 
consistency (transactions) 
constraints.  [See foreign keys, primary keys]
CONV() function  2nd 
conversion.  [See type conversion]
CONVERT() function  2nd 
    forcing type conversion 
    specifying character sets 
convert_character_set variable 
converting
    fixed-length columns to variable-length columns 
    table types  2nd 
    tables
        to MyISAM 
        to MySQL 4.1  2nd  3rd 
    to MyISAM tables 
    variable-length columns to fixed-length columns  2nd 
copying
    databases  2nd  3rd 
        advantages and disadvantages  2nd 
        with mysqldump utility 
    InnoDB and BDB tables  2nd 
copying and pasting
    queries  2nd 
copying.  [See also backing up]
COS() function 
cost
    selecting ISPs  2nd  3rd 
COT() function 
count()
    PHP query processing 
COUNT() function  2nd 
    generating summaries  2nd  3rd  4th  5th  6th  7th  8th  9th 
counters
    generating  2nd  3rd 
crash recovery
    administration duties 
CRC32() function 
create command 
CREATE DATABASE statement  2nd  3rd  4th  5th 
    displaying 
CREATE FUNCTION statement  2nd 
CREATE INDEX statement  2nd  3rd  4th  5th  6th 
CREATE privilege  2nd  3rd 
CREATE TABLE statement  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th  18th 
    creating tables from query results  2nd  3rd  4th 
    displaying 
    MERGE tables  2nd 
    provisional creation 
    table storage options  2nd 
    temporary tables  2nd 
CREATE TEMPORARY TABLES privilege 
cron jobs
    scheduling preventive maintenance 
crontab file
    scheduling log file expiration  2nd 
CROSS JOIN keyword
    retrieving rows from tables 
cross joins 
CURDATE() function  2nd 
currency.  [See money]
CURRENT_DATE() function 
CURRENT_TIME() function 
CURRENT_TIMESTAMP() function 
CURTIME() function 
customer service
    selecting ISPs  2nd 
customizing
    input handling  2nd 
    output formatting  2nd