Index L

[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] [Z]

language
    for error messages
        setting 
language variable 
large_files_support variable 
LAST INSERT ID option
    setting variables 
LAST_INSERT_ID() function  2nd 
    generating sequences  2nd  3rd  4th 
LCASE() function 
LEAST() function 
LEFT JOIN keyword  2nd  3rd  4th 
    retrieving rows from tables 
LEFT JOIN statement 
left joins  2nd  3rd  4th 
LEFT OUTER JOIN keyword 
    retrieving rows from tables 
LEFT() function 
leftmost prefixes
    indexes  2nd 
LENGTH() function 
less-than sign (<)
    comparison operator 
libmysqld (embedded MySQL server)  2nd  3rd 
libmysqld library 
libmysqld utility
    option groups used 
libraries
    C API  2nd 
LIKE clause 
    obtaining database or table information 
LIKE comparison operator 
LIKE pattern-matching operator  2nd  3rd  4th  5th  6th 
    query optimization  2nd 
LIMIT clause
    deleting table rows 
    generating summaries 
    joining SELECT statements together 
    limiting query results  2nd  3rd 
    retrieving rows from tables 
    unions 
    updating tables 
limiting
    query results  2nd  3rd 
    resource consumption  2nd 
LINES clause
    loading data 
linking
    C API  2nd 
    client programs  2nd  3rd 
Linux
    log rotation 
    starting server  2nd 
listening
    for network connections  2nd 
LN() function 
LOAD DATA FROM MASTER statement  2nd  3rd  4th 
LOAD DATA statement  2nd  3rd  4th  5th  6th  7th 
    enabling and disabling LOCAL capability  2nd 
    query optimization 
LOAD TABLE FROM MASTER statement  2nd 
load_defaults()
    reading option files  2nd  3rd  4th  5th 
    security 
LOAD_FILE() function 
loading data
    query optimization  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
loading.  [See inserting]
LOCAL keyword
    enabling and disabling in LOAD DATA statement  2nd 
    loading data 
    locking tables 
    setting variables  2nd 
local variables.  [See session variables]
local_infile variable 
localhost
    as hostname
        in grant tables  2nd 
localhost connections  2nd 
localization 
    character set support  2nd 
        converting tables to MySQL 4.1  2nd 
    error message language
        setting 
    time zone
        setting  2nd 
localstatedir variable
    data directory location 
LOCATE() function 
LOCK IN SHARE MODE clause
    retrieving rows from tables 
LOCK TABLE statement  2nd  3rd 
LOCK TABLES privilege  2nd  3rd 
LOCK TABLES statement  2nd 
locked_in_memory variable 
locking
    tables  2nd  3rd  4th  5th 
        read locks  2nd 
        read locks on all databases  2nd 
        write locks  2nd 
locking tables
    query optimization  2nd 
locks
    external locking  2nd  3rd 
    internal locking  2nd  3rd 
        read locks  2nd 
        read locks on all databases  2nd 
        write locks  2nd 
    scheduling queries with  2nd 
LOCL keyword
    displaying variables 
log files
    administration duties 
    backing up 
    binary log index file  2nd 
    binary update log  2nd  3rd 
    displaying information about  2nd 
    enabling logging  2nd 
    error log  2nd 
        on UNIX  2nd 
        on Windows 
    expiration  2nd 
        of numbered log files  2nd 
        of replication-related log files  2nd 
        scheduling  2nd 
        with log rotation  2nd  3rd 
    flushing  2nd 
    for multiple servers 
    general query log  2nd  3rd 
    in data directory  2nd  3rd  4th  5th 
        relocating  2nd 
    InnoDB logs 
    ISAM log 
    location for 
    needed for disaster recovery 
    query optimization 
    renaming  2nd  3rd 
    security
        reasons for 
    slow-query log  2nd  3rd 
    sorting 
    update log  2nd  3rd 
log variable 
LOG() function 
log_bin variable 
log_slave_updates variable 
log_slow_queries variable 
log_update variable 
log_warnings variable 
LOG10() function 
LOG2() function 
logical operators  2nd  3rd  4th  5th  6th 
    type conversion 
login accounts
    creating
        for MySQL  2nd 
login authentication
    PHP API  2nd  3rd  4th  5th  6th  7th 
logrotate utility 
LOGS option
    flushing caches 
long-form options
    versus short-form options 
long_query_time server variable 
long_query_time variable 
LONGBLOB string type  2nd 
LONGTEXT string type  2nd 
looks_like_number()
    Perl DBI utility function 
LOW PRIORITY clause
    deleting table rows 
    inserting rows 
    loading data 
    updating tables 
LOW PRIORITY keyword  2nd 
LOW PRIORITY UPDATES option
    setting variables 
LOW PRIORITY WRITE locks 
low_priority_updates variable 
LOWER() function 
lower_case_table_names variable  2nd 
LPAD() function 
ls command
    displaying data directory permissions 
    sorting log files 
LTRIM() function