Index T

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

table aliases 
table cache
    query optimization 
table handlers
    selecting  2nd 
table privileges (grant tables)
    list of  2nd 
table repair utilities
    access control to data directory 
table-level privileges
    granting  2nd 
table_cache variable  2nd  3rd 
Table_name column (grant tables) 
table_type variable 
tables
    accessing  2nd 
    altering  2nd  3rd  4th  5th  6th  7th  8th 
    analyzing  2nd 
    backing up  2nd  3rd  4th  5th 
    BDB 
        backing up  2nd 
        log files 
        on multiple servers 
    BDB tables
        AUTO_INCREMENT attribute 
    case sensitivity  2nd 
    changing column types  2nd 
    column declarations  2nd 
    converting
        to MyISAM 
        to MyISAM tables 
        to MySQL 4.1 
    converting to MySQL 4.1  2nd 
    creating  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th 
        from query results  2nd  3rd  4th 
        grade-keeping project example  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th 
        MERGE tables  2nd 
        provisional creation 
        storage options  2nd 
        temporary tables  2nd 
        U.S. Historical League example  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th 
    deleting rows  2nd 
    disk storage of  2nd 
    displaying  2nd 
    displaying column type information  2nd 
    displaying columns  2nd 
    displaying information about  2nd 
    displaying types of  2nd 
    dropping  2nd  3rd  4th 
    emptying  2nd 
    error checking  2nd  3rd 
    fragmentation 
    HEAP  2nd 
    HEAP tables
        AUTO_INCREMENT attribute 
    in data directory 
        BDB tables 
        HEAP tables 
        InnoDB tables 
        ISAM tables  2nd 
        maximum size  2nd  3rd 
        MERGE tables  2nd 
        MyISAM tables 
        naming conventions  2nd  3rd  4th 
        relocating  2nd 
        SQL statements for changes  2nd 
    indexes
        rebuilding  2nd 
    indexes.  [See indexes]
    InnoDB  2nd 
        backing up  2nd 
        configuring InnoDB tablespace  2nd  3rd  4th 
        increasing tablespace size  2nd 
        log files 
        on multiple servers 
    InnoDB tables
        AUTO_INCREMENT attribute 
        displaying information about 
        foreign keys  2nd 
    inserting rows  2nd 
    inserting rows into  2nd 
    ISAM 
    ISAM tables
        AUTO_INCREMENT attribute  2nd  3rd 
    joins.  [See joins]
    locking  2nd  3rd  4th  5th 
        query optimization  2nd 
        read locks  2nd 
        read locks on all databases  2nd 
        write locks  2nd 
    locks
        scheduling queries with  2nd 
    MERGE  2nd 
    MyISAM  2nd 
    MyISAM tables
        AUTO_INCREMENT attribute  2nd  3rd  4th 
    names
        case sensitivity 
    obtaining information about  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th 
    optimizing  2nd 
    portability  2nd 
    qualifying column references 
    records
        deleting  2nd  3rd  4th  5th 
        inserting  2nd  3rd  4th  5th  6th 
        retrieving  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  48th  49th  50th  51st  52nd 
        updating  2nd 
    recovering  2nd 
        foreign key relationships  2nd 
        InnoDB or BDB tables  2nd 
        with RESTORE TABLE statement  2nd 
    renaming  2nd  3rd 
    repairing  2nd  3rd  4th  5th  6th  7th 
        coordinating with server  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th 
        with CHECK TABLE and REPAIR TABLE statements  2nd  3rd 
        with myisamchk utility  2nd  3rd  4th  5th  6th  7th 
    restoring  2nd  3rd  4th 
    retrieving rows from  2nd  3rd  4th  5th  6th 
    sequence numbers
        adding column for  2nd 
    temporary tables
        creating 
    truncating  2nd 
    types of  2nd 
        converting between  2nd 
        determining support for  2nd 
        indexing features 
    unlocking  2nd 
    updating  2nd 
        avoiding endless updates 
TABLES option
    flushing caches 
TABLES WITH READ LOCK option
    flushing caches 
tables.  [See also databases]
tables_priv table (in grant table) 
TAN() function 
tar-format distributions
    unpacking 
TCP/IP connections
    establishing 
technical support
    selecting ISPs  2nd  3rd  4th 
tee command 
temporal data types.  [See date data types, time data types]
TEMPORARY keyword
    creating tables 
temporary tables
    creating  2nd  3rd 
TERMINATED BY clause
    loading data  2nd 
terminating
    server connections  2nd 
terminating server.  [See shutdown]
terminology for databases
    MySQL architecture terminology  2nd  3rd 
    query terminology  2nd 
    structural terminology  2nd  3rd  4th 
testing
    for NULL values
        Perl DBI API  2nd 
        PHP API  2nd 
    query optimization 
    type conversion  2nd  3rd 
text manipulation
    C API versus Perl and PHP APIs 
TEXT string type  2nd  3rd 
thread_cache_size variable 
thread_concurrency variable 
thread_stack variable 
threaded client functions
    C API  2nd 
threads
    displaying information about  2nd 
    killing 
    slave servers 
tilde (~)
    bitwise operator 
time data types 
time functions  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th 
TIME type  2nd  3rd  4th 
time zone
    setting  2nd 
time zones 
TIME_FORMAT() function 
TIME_TO_SEC() function 
TIMESTAMP option
    setting variables 
TIMESTAMP type  2nd  3rd  4th  5th  6th 
timezone variable 
TINYBLOB string type  2nd 
TINYINT numeric type  2nd 
TINYTEXT string type  2nd 
tmp_table_size variable 
TMPDIR environment variable 
tmpdir variable 
TO clause
    granting privileges 
TO_DAYS() function  2nd 
trace()
    Perl DBI debugging  2nd 
    Perl DBI handle method  2nd 
trace_msg()
    Perl DBI handle method  2nd 
TraceLevel attribute
    Perl DBI API 
    Perl DBI debugging 
tracing
    debugging Perl DBI API with  2nd  3rd  4th 
transaction_isolation variable 
transactions  2nd  3rd  4th  5th  6th  7th  8th 
    committing  2nd 
    in binary update log 
    non-transactional alternatives  2nd  3rd 
    Perl DBI API  2nd  3rd  4th 
    PHP API 
    reasons for using  2nd 
    rolling back  2nd 
    setting isolation level  2nd 
transferring databases.  [See copying databases]
triggers
    lack of support for 
TRIM() function 
trivial joins  2nd 
troubleshooting
    client programs
        function return values  2nd 
        NULL column values  2nd 
        uninitialized connection handler pointers  2nd 
        uninitialized result buffer pointers 
    linking client programs 
    privileges
        example of  2nd  3rd  4th 
    restarting server
        when unable to connect  2nd  3rd 
troubleshooting.  [See debugging]
TRUNCATE statement  2nd 
TRUNCATE TABLE statement 
TRUNCATE() function 
truncating
    tables  2nd 
truncation
    in numeric column types 
tuning performance.  [See query optimization]
tuning servers
    administration duties 
tuning.  [See performance tuning]
tx_isolation variable 
TYPE attribute
    Perl DBI API 
TYPE clause
    ALTER TABLE statement  2nd 
type conversion  2nd  3rd  4th  5th  6th 
    date and time types  2nd 
    forcing  2nd  3rd 
    illegal values  2nd 
    testing  2nd  3rd 
TYPE option
    creating tables 
types.  [See column types, data types]