Index_L

L

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