MySQL Cookbook

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]

labels argument (JSP)

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

latin1 character set 2nd 3rd

left arrow key, editing statements

LEFT JOIN clause 2nd

     holes in lists, filling with

     mismatched or unattached row, identifying and removing

LEFT( ) function 2nd 3rd 4th

     fixed-length substrings, sorting by

     variable-length substrings, sorting by

len PHP member name

LENGTH( ) function (SQL)

less than [See <]

lettercase

     converting

lettercase, converting

     "stubborn" stings

lexical order, sorting

     ENUM values

li( ) CGI.pm method (Perl)

lib directory

library files 2nd

     access privileges, setting

     installation locations, choosing

     Java

     Perl modules

LIKE operator 2nd 3rd

     removing duplicates and

     table structure and

LIMIT clause 2nd 3rd

     calculating values from expressions

     choosing appropriate values for

     eliminating duplicates from tables

     finding smallest/largest values

     MIN( ) and MAX( ) functions, summarizing with

     selecting rows from the middle of result set

     sort order and

     sorting query results and

line-ending sequence

line-kill character

linear regressions

linefeed (\n)

     different operating systems, reading files from

     LOAD DATA statement and

linefeed-terminated format

LINES clause 2nd

LINES TERMINATED BY clause

--lines-terminated-by option

lists (HTML)

literal( ) method (Python)

literals (string)

LOAD DATA statement 2nd

     bad input data, obtaining diagnostics

     CSV file, importing

     datafile lines, skipping

     duplicate key values, handling

     ignoring datafile columns

     importing data with

     input column order, specifying

     location of datafiles, specifying

     operating systems, reading files from

     preprocessing input values

     structure of datafiles, specifying

LOAD_FILE( ) function 2nd

     retrieving images or binary data

local hosts

LOCAL keyword

--local option

--local-infile option

localhost connections

     Perl

     Python

localhost default value 2nd

     Java, connecting

     Ruby, connecting with

LOCATE( ) function

LOCK TABLE statement 2nd

log tables

log_bin_trust_function_creators system variable

LogFormat

login accounts

logs directory

LONGBLOB data type

     image, storing

LONGTEXT data type

lookup tables, validating with

looping in templates

LOWER( ) function

LPAD( ) function 2nd