Index I

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

IDENTIFIED BY clause
    changing passwords 
    granting privileges  2nd  3rd 
IF EXISTS clause
    dropping databases 
    dropping tables 
IF NOT EXISTS clause
    creating databases 
    creating tables 
IF NOT EXISTS modifier (creating tables) 
IF() function  2nd 
    sorting query results 
    type conversion 
IFNULL() function 
IGNORE clause
    inserting rows 
    updating tables 
IGNORE INDEX clause
    retrieving rows from tables 
IGNORE keyword
    altering tables 
illegal values
    type conversion  2nd 
images
    handling in queries  2nd 
implicit data types 
implode()
    PHP president quiz example 
IN clause
    obtaining database or table information 
IN keyword
    subselects  2nd 
IN() comparison operator  2nd 
include files
    PHP API  2nd  3rd  4th  5th  6th  7th  8th 
include statement (PHP API)
    versus require statement (PHP API) 
include_once statement (PHP API) 
including
    header files 
INDEX DIRECTORY option
    creating tables 
INDEX privilege  2nd  3rd 
indexes  2nd  3rd 
    binary log index file  2nd 
    case sensitivity 
    composite indexes  2nd 
    creating  2nd  3rd  4th  5th 
        when creating tables 
    declarations  2nd 
    displaying information about  2nd 
    dropping  2nd  3rd 
    features for different table types 
    for query optimization  2nd 
        advantages of  2nd  3rd  4th 
        disadvantages of  2nd 
        loading data  2nd  3rd 
        tips for setting up  2nd  3rd 
        usage with MySQL query optimizer  2nd  3rd  4th 
    foreign keys  2nd  3rd  4th  5th 
        alternatives to  2nd 
    FULLTEXT  2nd  3rd  4th  5th  6th 
        Web-based applications searching example  2nd  3rd  4th 
    prefixes  2nd 
    PRIMARY KEY  2nd 
    rebuilding  2nd 
    resorting 
    selecting column types  2nd  3rd 
    synthetic indexes 
    unique  2nd  3rd 
    unique indexes 
INET_ATON() function 
INET_NTOA() function 
information gathering functions
    C API  2nd  3rd  4th 
    PHP API  2nd  3rd 
init_file variable 
initialization
    of data directory and grant tables
        MySQL installation  2nd 
initializing
    user table  2nd 
inndo_log_file_size variable 
INNER JOIN keyword
    retrieving rows from tables 
InnoDB logs 
InnoDB options
    mysqld server  2nd 
InnoDB tables  2nd 
    AUTO_INCREMENT attribute 
    backing up  2nd 
    configuring InnoDB tablespace  2nd  3rd  4th 
    displaying information about 
    foreign keys  2nd 
    in data directory 
    increasing tablespace size  2nd 
    log files 
    maximum size  2nd 
    on multiple servers 
    portability  2nd 
    recovering  2nd 
InnoDB tablespace
    in data directory 
        relocating  2nd 
InnoDB-related server variables
    list of  2nd 
innodb_additional_mem_pool_size variable 
innodb_buffer_pool_size variable  2nd 
innodb_data_file_path option  2nd 
innodb_data_file_path variable 
innodb_data_home_dir option  2nd 
innodb_data_home_dir variable 
innodb_fast_shutdown variable 
innodb_file_io_threads variable 
innodb_flush_log_at_trx_commit variable 
innodb_flush_method variable 
innodb_force_recovery variable  2nd 
innodb_lock_wait_timeout variable 
innodb_log_arch_dir variable 
innodb_log_archive variable 
innodb_log_buffer_size variable  2nd 
innodb_log_file_size variable 
innodb_log_files_in_group variable 
innodb_log_filex_in_group variable 
innodb_log_group_home_dir variable 
innodb_mirrored_log_groups variable 
innodb_thread_concurrency variable 
input formats
    date and time types  2nd  3rd 
input handling
    customizing  2nd 
input line editing
    queries  2nd  3rd 
input parameters
    CGI.pm Perl module  2nd 
    PHP API  2nd  3rd  4th  5th  6th 
INSERT DELAYED statement  2nd  3rd 
INSERT ID option
    setting variables 
INSERT METHOD option
    creating tables 
INSERT privilege  2nd  3rd 
INSERT statement  2nd  3rd  4th  5th 
    modifying grant tables  2nd  3rd 
    query optimization  2nd 
INSERT() function 
inserting
    records  2nd  3rd  4th  5th  6th 
    rows into tables  2nd  3rd  4th 
install_driver()
    Perl DBI class method 
installation
    Apache
        obtaining distribution  2nd  3rd 
        on UNIX  2nd  3rd 
        on Windows 
    client software
        reasons for  2nd 
    mailing lists for help 
    MyODBC
        on Windows  2nd  3rd 
    MySQL
        obtaining distribution  2nd  3rd 
    MySQL on UNIX  2nd  3rd  4th  5th  6th 
        Apache and PHP installation  2nd  3rd 
        binary distributions  2nd 
        data directory and grant table initialization  2nd 
        login account creation  2nd 
        Perl DBI support  2nd  3rd 
        RPM distributions  2nd  3rd 
        server startup  2nd 
        source distributions  2nd  3rd 
    MySQL on Windows  2nd  3rd  4th 
        Apache and PHP installation 
        MyODBC installation  2nd  3rd 
        Perl DBI support  2nd 
    Perl modules
        obtaining distribution  2nd  3rd 
        on UNIX  2nd  3rd 
        on Windows  2nd 
    PHP
        obtaining distribution  2nd  3rd 
        on UNIX  2nd  3rd 
        on Windows 
installing
    CGI scripts 
INSTR() function 
INT numeric type  2nd 
integer testing
    PHP API 
integers  2nd  3rd  4th  5th 
    numeric types.  [See numeric types]
    versus floating-point numbers  2nd 
integration
    MySQL with other applications  2nd 
    MySQL with web environment  2nd  3rd  4th  [See also PHP API]
interactive query program example  2nd 
interactive_timeout variable 
internal locking  2nd  3rd 
    read locks  2nd 
    read locks on all databases  2nd 
    write locks  2nd 
internal security  2nd  3rd 
    for data directory  2nd  3rd  4th  5th 
    for option files  2nd 
    for socket file  2nd 
    reasons for implementing  2nd 
internationalization 
    character set support  2nd 
        converting tables to MySQL 4.1  2nd 
    error message language
        setting 
    time zone
        setting  2nd 
internet service providers.ISPs 
interpreted languages
    standalone versus module interpreters  2nd  3rd  4th 
    versus compiled languages  2nd 
INTERVAL() function 
INTO DUMPFILE clause
    retrieving rows from tables 
INTO keyword
    inserting rows 
INTO OUTFILE clause
    retrieving rows from tables 
invoking
    scripts with parameters
        CGI.pm Perl module  2nd  3rd  4th  5th  6th 
IO THREAD option
    starting and stopping slave servers 
IS NOT NULL comparison operator  2nd  3rd 
IS NULL comparison operator  2nd  3rd 
IS_BLOB() macro
    C API 
IS_FREE_LOCK() function  2nd 
is_int()
    PHP integer testing 
IS_NOT_NULL() macro
    C API 
IS_NUM() macro
    C API 
IS_PRI_KEY() macro
    C API 
ISAM log 
ISAM tables 
    AUTO_INCREMENT attribute  2nd  3rd 
    in data directory  2nd 
    maximum size 
    portability 
isamchk utility  2nd  3rd  4th  5th  6th 
    options
        list of  2nd  3rd 
        standard options supported 
    scheduling preventive maintenance  2nd 
    variables
        list of  2nd 
    versus myisamchk utility  2nd 
ISNULL() function 
isolation (transaction) 
isolation level of transactions
    setting  2nd 
ISPs
    (internet service providers) 
    selecting  2nd 
        bandwidth considerations 
        general criteria  2nd  3rd  4th  5th  6th  7th  8th  9th 
        MySQL-specific criteria  2nd  3rd  4th 
        needs assessment  2nd 
        services provided  2nd 
isset()
    PHP testing for NULL values 
ISSUER keyword
    granting privileges 
ISSUER option
    granting privileges