|
|
IF() function, 563–564
IFNULL() function, 564–565
IGNORE keyword, for LOAD DATA statement, 323
implementation phase of database lifecycle, 248
example, 254–255
IN comparison operator, 71, 74, 507
InactiveDestroy attribute (Perl DBI), 611
include directory, 452
inconsistent read, 108
incremental update, 124
INDEX privilege, 436
Indexed Sequential Access Method (ISAM) table type, 56
indexes, 128, 213
basics, 127–128
calculations and, 162
creating, 129–141
full-text index, 132–140
ordinary index, 131–132
from part of field, 141
primary key, 129–131
unique index, 140–141
dropping or changing, 152
effective use, 153–157
EXPLAIN to analyze use for SELECT, 157–164
leftmost prefixes, 156–157
multicolumn, and auto increment fields, 150–151
INET_ATON() function, 565
INET_NTOA() function, 565
info directory, 463
information, 212, 239
information retrieval, 13–23
advanced queries, 29–35
changing column headings, 30
finding day in year, 30
joining columns, 30
joining tables, 32–35
with multiple tables, 31–32
average, minimum and total values, 22–23
calculations, 23
counting, 21–22
distinct records, 21
grouping in query, 37–38
limiting number of results, 18–20
order of processing conditions, 15–16
pattern matching, 16–17
returning maximum value, 20–21
sorting, 17–18
init function
for aggregate user-defined functions, 201
for standard user-defined functions, 195–197
args parameter, 196
initd parameter, 196
message parameter, 197
initd parameter
of user-defined init function, 196
of user-defined main function, 197
init_file variable, 381
inner joins, 86
InnoDB HotBackup, 332
InnoDB tables, 65–66
backups of, 332–335
configuration, 374
consistent reads, 107–108
read locks for sharing, 111–112
read locks for updating, 109–111
transactions in, 105–107
innodb_additional_mem_pool_size variable, 382
innodb_buffer_pool_size variable, 382
innodb_data_file_path variable, 374, 382
innodb_data_home_dir variable, 382
innodb_file_io_threads variable, 382
innodb_flush_log_at_trx_commit variable, 382
innodb_flush_method variable, 383
innodb_lock_wait_timeout variable, 383
innodb_log_arch_dir variable, 382
innodb_log_archive variable, 382
innodb_log_buffer_size variable, 382
innodb_log_files_in_group variable, 382
innodb_log_file_size variable, 382
innodb_log_group_home_dir variable, 382
innodb_mirrored_log_groupsvariable, 382
INSERT() function, 532
INSERT privilege, 436, 489
INSERT statement, 12, 96–98, 489– 490
vs. LOAD DATA statement, 172
programming, 181
using one statement for multiple records, 12–13
insert_id() method (Python), 623
INSERT_ID variable, 392, 495
insertRow() method (Java), 636
installing MySQL, 451–468
avoiding common problems, 464–466
in compiling, 465
in startup, 464–465
in Windows, 466
compiling optimally, 461
multiple servers on same machine, 461–464
source code vs. binary distribution, 451–453
on Unix, 455–461
binary (rpm) distribution, 458
binary (tar) distribution, 455–457
from source code, 459–461
upgrading from version 3 to 4, 466–468
on Windows, 453–455
installing user-defined functions, 192–194
instance, 242
INSTR() function, 532–533
INT column type, 10, 43
INTEGER column type, 43
integration testing, 189
interactive_timeout variable, 383
"Internal compiler error:" error message, 465
intersection entity type, 244, 245
IS NOT NULL comparison operator, 70
IS NULL comparison operator, 70, 505–506
is null parameter, of user-defined main function, 197
isAfterLast() method (Java), 636
ISAM (Indexed Sequential Access Method) table type, 56
ISAM log, 272
isAutoIncrement() method (Java), 640
isBeforeFirst() method (Java), 636
isCaseSensitive() method (Java), 641
isClosed() method (Java), 628
.ISD file extension, 56
isDefinitelyWritable() method (Java), 641
isFirst() method (Java), 636
IS_FREE_LOCK() function, 565–566
isLast() method (Java), 636
.ISM file extension, 56
isNullable() method (Java), 641
isolation of transactions, 256
isReadOnly() method (Java), 628, 641
isSearchable() method (Java), 641
isSigned() method (Java), 641
isWritable() method (Java), 641
|
|