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 |