|
|
language support in MySQL, 408– 413
character set, 409–413
error message display, 409
language variable, 383
large_file_support variable, 383
last() method (Java), 637
lasth attribute (Perl DBI), 617
LAST_INSERT_ID() function, 144, 566
problems with, 148–150
LAST_INSERT_ID variable, 392, 496
Latin1 (ISO-8859-1) character set, 409
LCASE() function, 533
LEAST() function, 548–549
LEFT() function, 533
left (left outer) joins, 87–89
leftmost prefixes
EXPLAIN statement with, 163–164
for indexes, 156–157
LENGTH() function, 533–534
length parameter, of user-defined main function, 197
lib directory, 452, 463
libexec directory, 463
libraries, shared, avoiding common problems, 465
LIKE clause in SELECT statement, 16–17, 70, 506–507
wildcard (%) with, 74–75
LIMIT clause, in SELECT statement, 18–20
LN() function, 549
LOAD DATA FROM MASTER statement, 339, 343
LOAD DATA INFILE statement, 490–491
LOAD DATA LOCAL statement, and security, 449
LOAD DATA statement, 13
and enumerated fields, 49
vs. INSERT, 172
to restore backups from SELECT INTO, 318–325
LOAD_FILE() function, 534
LOCAL keyword, 13
for LOAD DATA statement, 324
security issues, 325
LOCATE() function, 534
LOCK TABLES privilege, 436, 489
LOCK TABLES statement, 118–119, 491
locked_in_memory variable, 383
locking
by row, in InnoDB tables, 65, 118
tables, 118–124
avoiding, 124
log files, 263
LOG() function, 549
log variable, 383
LOG2() function, 550
LOG10() function, 549
log_bin variable, 383
logging, 272–279
binary update log, 273–276
error log, 272–273
query log, 273
rotating logs, 277–279
slow query log, 276–277
logical database design, 245–248
logical operators in SQL, 68, 499–500
AND, &&, 68, 499
NOT, !, 68, 500
OR, ||, 68, 500
log_slave_updates variable, 383
log_update variable, 383
LONGBLOB column type, 46
long_query_time variable, 383
LongReadLen attribute (Perl DBI), 611–612
LONGTEXT column type, 46
LongTrucOK attribute (Perl DBI), 612
looks_like_number method (Perl DBI), 599
LOW PRIORITY keyword, for LOAD DATA statement, 324
LOWER() function, 535
lower_case_table_names variable, 383
LOW_PRIORITY keyword, 121
LOW_PRIORITY_UPDATES variable, 392, 496
LPAD() function, 535
LTRIM() function, 535–536
|
|