Mysql: the Definitive Guide to Using, Programming, and Administering Mysql 4.1 and 5.0

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 2nd

language of, selecting (internationalization/localization) 2nd language system variable

large_files_support 2nd large_files_support system variable

LAST_DAY() function last_insert_id 2nd

last_insert_id session-only system variable

LAST_INSERT_ID() function 2nd 3rd 4th 5th

Last_query_cost 2nd

Last_query_cost status variable LCASE() function ldata option

leading spaces 2nd 3rd

LEAST() function

LEAVE 2nd 3rd

LEAVE statement LEFT JOIN clause 2nd

left joins 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th

left outer left outer joins

LEFT() function leftmost prefixes 2nd 3rd 4th

leftmost prefixes (index usage guidelines) 2nd

legal characters

length members 2nd

length of (query optimization)

length of, determining

LENGTH() function

length, determining

less-than sign (<), comparison operator 2nd 3rd

libmysqld 2nd 3rd 4th

libmysqld (embedded MySQL server) 2nd 3rd

libs_r option

license 2nd

license system variable

LIKE clause

LIKE clauses 2nd 3rd

LIKE clauses, trailing LIKE operator 2nd 3rd 4th 5th LIKE operators 2nd

LIKE pattern-matching operator 2nd 3rd

LIKE patterns LIKE patterns (MySQL query optimizer usage guidelines)

LIMIT clause 2nd 3rd 4th 5th 6th 7th 8th

LIMIT clauses 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th

limiting permissions 2nd 3rd 4th 5th

limiting query results 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th

limiting resource consumption 2nd

limitQuery () 2nd 3rd 4th limitQuery () method (PEAR DB module) 2nd

LINEFROMTEXT() function LINEFROMWKB() function

LINES clause 2nd 3rd 4th LINESTRING 2nd

LINESTRING spatial data type

LINESTRINGFROMTEXT() function

LINESTRINGFROMWKB() function

linking 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th linking in 2nd list of 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th 35th 36th 37th 38th 39th 40th 41st 42nd 43rd 44th 45th 46th 47th 48th 49th 50th 51st 52nd 53rd 54th 55th 56th 57th 58th 59th 60th 61st 62nd 63rd 64th 65th 66th 67th 68th 69th 70th 71st 72nd 73rd 74th 75th 76th 77th 78th 79th 80th 81st 82nd 83rd 84th 85th 86th 87th 88th 89th 90th 91st 92nd 93rd 94th 95th 96th 97th 98th

list() method

lmyisampack utility

LN() function

LOAD DATA 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th LOAD DATA FROM MASTER statement

LOAD DATA statement 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th

LOAD DATA statements 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th LOAD É FROM MASTER 2nd 3rd 4th 5th 6th

LOAD É FROM MASTER statement 2nd LOAD INDEX INTO CACHE 2nd 3rd 4th 5th 6th

LOAD INDEX INTO CACHE statement 2nd 3rd 4th

load_defaults()

load_defaults() function 2nd 3rd 4th 5th 6th 7th

load_defaults() functions

LOAD_FILE() function

load_image() function 2nd

loading data 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th

loading data (query optimization) 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th

LOCAL capability 2nd 3rd 4th

LOCAL capability, enabling/disabling 2nd 3rd 4th

LOCAL clause 2nd 3rd 4th

local_infile 2nd

local_infile system variable

localhost 2nd

localhost hostname 2nd

localhost hostnames 2nd localization 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th LOCALTIME() function

LOCALTIMESTAMP() function

LOCATE() function locating 2nd

locating in mysql database

locating user accounts 2nd 3rd

location in 2nd

location of 2nd 3rd 4th 5th

LOCK IN SHARE MODE clause 2nd

LOCK TABLE 2nd 3rd 4th 5th 6th LOCK TABLE statement 2nd 3rd 4th

LOCK TABLES 2nd 3rd 4th 5th 6th 7th LOCK TABLES privilege

LOCK TABLES privileges (grant tables) 2nd LOCK TABLES statement

locked_in_memory 2nd

locked_in_memory system variable

locking all databases to read-only access 2nd

locking protocols (database maintenance) 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th log 2nd log file expiration 2nd 3rd

log file location

log file maintenance 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th 35th 36th 37th 38th 39th 40th 41st 42nd 43rd 44th 45th 46th 47th 48th 49th 50th 51st 52nd 53rd 54th 55th 56th 57th 58th 59th 60th 61st 62nd 63rd 64th 65th 66th

log files 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th 35th 36th 37th 38th 39th 40th 41st 42nd 43rd 44th 45th 46th 47th 48th 49th 50th 51st 52nd 53rd 54th 55th 56th 57th 58th 59th 60th 61st 62nd 63rd 64th 65th 66th 67th 68th 69th 70th 71st 72nd 73rd 74th 75th 76th 77th 78th 79th 80th 81st 82nd 83rd 84th 85th 86th 87th 88th 89th 90th 91st 92nd 93rd 94th 95th 96th 97th

log files, binary logs 2nd log files, error logs

log files, general logs 2nd

log files, location of log files, maintaining 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th 35th 36th 37th 38th 39th 40th 41st 42nd 43rd 44th 45th 46th 47th 48th 49th 50th 51st 52nd 53rd 54th 55th 56th 57th 58th 59th 60th 61st

log files, relocating in 2nd log files, renaming

log files, security

log rotation 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd 34th 35th 36th 37th 38th 39th 40th 41st 42nd

log rotation, fixed-name log files 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th

log rotation, Unix operation 2nd 3rd 4th 5th 6th

log rotation, Windows operation 2nd 3rd 4th 5th 6th

log system variable

LOG() function

log-slow-queries option

log-update option

LOG10() function

LOG2() function 2nd

log_bin 2nd

log_bin system variable

log_error 2nd

log_error system variable

log_slave_updates 2nd log_slave_updates system variable log_slow_queries 2nd

log_slow_queries system variable

log_update 2nd log_update system variable

log_warnings 2nd

log_warnings system variable

logical 2nd 3rd 4th 5th 6th 7th

logical operators 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th

login accounts 2nd 3rd 4th

logrotate utility long_query_time 2nd

long_query_time system variable long_query_time variable

LONGBLOB 2nd 3rd 4th LONGBLOB binary data type 2nd

LONGTEXT 2nd 3rd 4th

LONGTEXT nonbinary data type 2nd

looks_like_number 2nd 3rd

looks_like_number function (Perl DBI) LOOP 2nd 3rd LOOP statement

LOW_PRIORITY keyword 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th

low_priority_updates 2nd

low_priority_updates system variable

LOWER() function 2nd lower_case_file_system 2nd

lower_case_file_system system variable

lower_case_table_names 2nd 3rd 4th lower_case_table_names system variable 2nd

LPAD() function ls command 2nd

LTRIM() function