MySQL Cookbook

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]

i (case-insensitive) flag for Perl pattern constructors

%i format sequence

IDENTIFIED BY statement

identifiers

IDs (sessions)

IF( ) function 2nd 3rd 4th

IFNULL( ) function 2nd 3rd

IGNORE keyword

--ignore option

IGNORE statement

--ignore-lines=n option

images

     retrieving

     storing

<img> HTML image tag 2nd

import issues

import statement

     Java

     Python

IN BOOLEAN MODE clause

IN parameter

include keyword (PHP)

include_path PHP variable 2nd 3rd 4th 5th 6th

include_path variable (Perl)

indexed Ruby member name

indexes

     removing duplicates and

inequality, comparing strings for

INET_ATON( ) function, sorting IP values

INFORMATION_SCHEMA 2nd 3rd

     ENUM/SET column values and

     row deletions, effects of

     table column definitions, accessing

     table metadata, validating with

INNER JOIN clause

InnoDB engine 2nd 3rd

     transactional storage engines and

INOUT parameter

input columns

<input> HTML tag 2nd

input streams

input-line editing

input-processing loops, writing

INSERT IGNORE statement 2nd

INSERT statement

     creating sample tables and

     editing statements

     ON DUPLACATE KEY UPDATE statement

     PHP

     placeholders, using

         Perl

     Ruby

         placeholders and

     saving query results in tables

     special characters and

INSERT statements

     exporting tables as SQL formatted text file

insert_id( ) method (Python)

INT data type

integrity issues

interactive mode

     output, sending to files/programs

interactive record editing

intervals (dates and times), calculating

INTO clause

INTO OUTFILE statement 2nd

IP address (dotted-quad), sorting in numeric order

IP values (dotted-quad), sorting

IS NOT NULL comparison operator

IS NULL comparison operator

ISNULL( ) function

ISO formats 2nd 3rd

     exporting non-ISO formats

     importing non-ISO date values

isset( ) function (PHP)

iteration in templates

     PageTemplate and