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]
LAST_INSERT_ID( )
client-specific count value, retrieving with
connection-specific basis for value
leap year calculations
conditions for determining
four-digit year values and
month-length calculations, using for
Perl, using
testing a year for leap year
year-length calculations using
LEFT JOINs
cascaded deletes and childless parent records
consistency checks, using for
identifying unattached records
NOT IN( ) subselects, using in place of
ON clauses and
related table updates, using for
in self-joins
unattached records, finding and removing from related tables
WHERE clauses and
LEFT( )
li( ) (Perl)
library files
connection, error checking
installation location
ownership and access issues
security advantages of
writing
LIKE clauses
database existence, testing for with
tables, testing for existence using
LIKE operators
LIMIT clause
2nd
3rd
4th
appropriate values, choosing
duplicate records, using to remove
LIMIT values, calculating from expressions
sorting of results
line terminators, different operating systems
line-ending sequences
linear regressions, calculating
LINES clause
format characters, specification in hex notation
LINES TERMINATED BY clause
2nd
links
using to sort query results in a web page
Linux
Tomcat servers, starting and stopping
lists
web scripting query results as
definition lists
nested lists
ordered lists
unmarked lists
unordered lists
LOAD DATA statement
2nd
[See also data transfers]
CSV files, importing
datafile location, specifying
datafile, contents, checking
default file format for
duplicate index values, handling
email damage to datafiles
end of process messages, interpreting
error warning
diagnostic utility for
error warnings
escaped characters, handling
file format, specifying
FTP transfers, data load errors caused by
IGNORE n LINES clause
important limitations
LINES TERMINATED BY clause
LOCAL keyword
absolute and relative pathnames
NULLs, representation by
quoted values, handling
reading files from different operating systems
skipping datafile columns
specifying column input order
load_diag.pl
limitations
logging on MySQL logging enabled servers
options to
LOAD_FILE( )
localtime( ) (Perl)
LOCATE( )
case sensitivity
LOCK statement
locking
transactions, as alternative to
logfiles
analyzing
indexing of
purging and archiving
LogFormat directives
LogFormat field specifiers
logging
of interactive sessions
of users
to server databases
logfiles, analyzing
set up
LONGBLOB columns
lookup tables
caching of checked values in a hash
data storage space, saving with
hashes, constructing from
using for creation of new records
LOWER( )
2nd
LPAD( )
canonizing dates to ISO standard
|
Main Menu
|
