MYSQL in a Nutshell (In a Nutshell (OReilly))

Index

[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 option (mysqld) LAST flag (HANDLER)

LAST_DAY( ) function 2nd

LAST_INSERT_ID( ) function 2nd 3rd last_insert_id( ) function (Perl DBI) lasth attribute (Perl DBI) LCASE( ) function 2nd LD_RUN_PATH environment variable

LEAST( ) function --ledir option (mysqld_safe) LEFT JOIN clause LEFT keyword (JOIN clause)

LEFT( ) function 2nd 3rd

LENGTH( ) function 2nd licensing, MySQLLIKE clause

     CREATE TABLE statement 2nd

     SHOW CHARACTER SET statement     SHOW COLLATION statement

     SHOW COLUMNS statement     SHOW DATABASES statement     SHOW STATUS statement

     SHOW TABLE STATUS statement

     SHOW VARIABLES statement

LIKE operator 2nd 3rd

LIMIT clause     DELETE statement 2nd

     HANDLER statement

     SELECT statement 2nd 3rd 4th 5th     SHOW BINLOG EVENTS statement

     SHOW ERRORS statement     SHOW WARNINGS statement LINES STARTED BY clause (LOAD DATA INFILE)

LINES STARTING BY option (SELECT)

LINES TERMINATED BY option (SELECT)

--lines-terminated-by option

     mysqldump utility

     mysqlimport utility

Linux distribution 2nd

Linux environment 2nd 3rd

LN( ) function

LOAD DATA FROM MASTER statement 2nd

LOAD DATA INFILE statement

     converting data

     example

     granting privileges for

     mysql_info( ) and

     mysqlbinlog utility and

     mysqlimport utility     syntax 2nd

LOAD INDEX INTO CACHE statement

LOAD LOCAL INFILE statement LOAD MASTER DATA statement LOAD TABLE...FROM MASTER statement 2nd LOAD_FILE( ) functionLOCAL flag

     ANALYZE TABLE statement     FLUSH statement     LOAD DATA INFILE statement     OPTIMIZE TABLE statement

     REPAIR TABLE statement

     SET statement     SHOW VARIABLES statement --local option (mysqlimport)

--local-load option (mysqlbinlog)

LOCALTIME( ) function 2nd 3rd LOCALTIMESTAMP( ) function 2nd

LOCATE( ) function 2nd 3rd 4th LOCK IN SHARE MODE flag (SELECT) LOCK TABLES privilege (GRANT/REVOKE)

LOCK TABLES statement 2nd 3rd

--lock-tables option

     mysqldump utility 2nd 3rd 4th

     mysqlimport utilitylog files

     displaying 2nd 3rd

     flushing     purging

--log option     mysqld program     mysqld_multi program

LOG( ) function

--log-bin option (mysqld)

--log-bin-index option (mysqld)

--log-error option

     mysqld program

     mysqld_safe program

--log-isam option (mysqld)

--log-long-format option (mysqld)

--log-queries-not-using-indexes option (mysqld)

--log-short-format option (mysqld) 2nd

--log-slow-queries option (mysqld) 2nd

--log-update option (mysqld)

--log-warnings option (mysqld)

LOG10( ) function

LOG2( ) function

logarithm 2nd 3rd 4th logging in, MySQL 2nd

logical operators 2nd

LONGBLOB datatype LongReadLen attribute (Perl DBI) LONGTEXT datatype LongTruncOK attribute (Perl DBI) looks_like_number( ) function (Perl DBI)

--low-priority option (mysqlimport) --low-priority-updates option (mysqld)LOW_PRIORITY flag     DELETE statement

     INSERT statement

     LOAD DATA INFILE statement     LOCK TABLES statement     mysqlimport utility

     REPLACE statement

LOWER( ) function 2nd LPAD( ) function

LTRIM( ) function 2nd