MYSQL in a Nutshell (In a Nutshell (OReilly))

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

IBM AIX environmentIF EXISTS flag

     DROP DATABASE statement

     DROP TABLE statement 2nd     DROP VIEW statementIF NOT EXISTS flag     CREATE DATABASE statement     CREATE TABLE statement

IF( ) function 2nd 3rd IFNULL( ) function IGNORE clause 2ndIGNORE flag

     ALTER TABLE statement

     CREATE TABLE statement     DELETE statement     INSERT statement 2nd

     LOAD DATA INFILE statement

IGNORE INDEX option (JOIN clause) IGNORE LEAVES clause (LOAD INDEX INTO CACHE)

--ignore option (mysqlimport) --ignore-lines option (mysqlimport) IGNORE...LINES clause (LOAD DATA INFILE) 2nd

importing

     data 2nd 3rd

     database format

     dump files and IN clause (SHOW BINLOG EVENTS)

IN operator

InactiveDestroy attribute (Perl DBI) INDEX indexes 2nd

INDEX keyword     CACHE INDEX statement     LOAD INDEX INTO CACHE statement

INDEX privilege (GRANT/REVOKE)

indexes

     adding to tables 2nd

     benefit of

     creating

     displaying 2nd

     joined tables and

     listing 2nd 3rd

     primary key

     removing 2nd 3rd

     sorting 2nd

     specifying specific

INET_ATON( ) function 2nd

INET_NTOA( ) function 2nd

--information option (myisamchk)

--init-file option (mysqld) INNER keyword (JOIN clause)

InnoDB storage engines

--innodb-safe-binlog option (mysqld) INSERT DATA INFILE statement 2nd 3rd INSERT INTO... VALUES... statement INSERT INTO...SELECT... statement INSERT privilege (GRANT/REVOKE) 2nd 3rd

INSERT statement     DELAYED flag     editing tables     functionality

     granting privileges for

     IGNORE flag     mysql_affected_rows( ) and 2nd     mysql_autocommit( ) and

     mysql_commit( ) and

     mysql_insert_id( ) and     mysqldump utility 2nd 3rd

     READ LOCAL flag and     REPLACE statement and     rows( ) and

     SELECT statement and

     syntax

     usefulness of

INSERT( ) function 2ndinstallation

     ActivePerl

     adjustments after     choosing a distribution 2nd

     Linux RPM distribution 2nd     Mac OS X distribution     Novell NetWare distribution

     Perl

     Unix binary distributions 2nd

     Unix source distribution

     Windows distributions 2nd

installed_versions( ) function (Perl DBI)

INSTR( ) function

INT datatype

INTEGER datatype 2nd 3rd

INTERNAL format

INTERVAL( ) function

INTO DUMPFILE clause (SELECT)

INTO keyword

     INSERT statement

     REPLACE statement

     SELECT statement

INTO OUTFILE clause (SELECT)IP addresses

     binding

     converting 2nd     displaying     reverse host lookup IS NOT NULL operator IS NOT operator

IS NULL operator IS operator IS_FREE_LOCK( ) function IS_USED_LOCK( ) function

isamchk utility

ISNULL( ) function ISO format