MySQL: Essential Skills

I

IF function, 143145, 171

IF NOT EXISTS option, 62

IFELSE control structure, 342343

IFNULL function, 168169

IGNORE clause, 81, 109

importing

MySQL data into Access, 273275

MySQL data into Excel, 271273

using ODBC, 272273

IN function, 142143

index buffers, 202

index fields, 216

index numbers , 52, 70

INDEX reserved word, 92

indexes. See also keys

creating, 9294

described, 3

dropping, 91, 92

location of, 92

multiple-field, 9495

stored information and, 61

uses for, 9394

INNER JOIN function, 184185, 190

InnoDB parameters, 202203

InnoDB tables, 56, 5960

INSERT command, 6772

installing MyODBC, 1922

installing MySQL

on Linux, 2528

on Windows, 814

INSTR function, 157158

INT integer type, 4142

INTEGER variables , 334

integers, 4143

considerations, 4243

signed, 4142

size , 4243

unsigned, 4142

variables, 334

INTERVAL clause, 167

INTERVAL modifiers, 167

ISAM table type, 56

ISAM tables, 5657