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]
-s option (--silent)
script program
ScriptAlias directive
2nd
scrolling lists
multiple pick
scrolling_list( ) (Perl)
SDK (Java Software Development Kit)
Tomcat servers and
search interfaces, implementing
search_state.pl
SEC_TO_TIME( )
2nd
3rd
4th
SECOND( )
2nd
seconds values, conversion
to date-and-time
to time
security
encapsulation, advantages of
library files and
option files
scripts in the document tree, risks
sed
delimiters, selection using
SELECT statement
columns, displaying
with column name aliases
SELECT DATABASE( )
SELECT DISTINCT statement
SELECT É INTO OUTFILE statement
FILE privilege, requirement for
SELECT statement
2nd
calculations, using for
columns, displaying
output order, control ling
eliminating duplicate rows
identifying unattached records for deletion
Perl placeholders for
selection criteria, testing
uses for
WHERE clauses
aliases and input columns
finding NULL values
negation operators
NULLs, query conditions that miss
SELECT USER( )
SELECT VERSION( )
customizing applications and
SELECT... WHERE query
metadata, getting with
portability across DBMSs
selectall_arrayref( ) (Perl)
for obtaining metadata
placeholders, using with
selectall_hashref( ) (Perl)
for obtaining metadata
selectcol_arrayref( ) (Perl)
selectrow_array( ) (Perl)
placeholders, using with
selectrow_arrayref( ) (Perl)
selectrow_hashref( ) (Perl)
self-joins
aliases and
cumulative sums, finding
duplicates, eliminating from
excluding the reference value from results
LEFT JOIN self-joins
without reference values
running averages, finding
successive rows, calculating differences between
seqence columns, need for
table aliases and
types of questions requiring
semicolon (;)
2nd
sequences
event counts, using for
extending sequence range
generating
lack of portability
multiple sequences in one table, creating
record deletions, impact on
repeating sequences (cycles), generating
resequencing, advisability
retrieving values for
reusing values at the top
server-side retrieval
compared to client-side methods
starting value, setting
using as counters
server-side storage
servers
[See also mysqld]2nd
databases on, listing
metadata, getting
Java, using
raw protocol
table types, determining support for
user accounts, creating
servers (MySQL)
monitoring
impact of monitoring
sess_track.jsp
sess_track.php
sess_track.pl
session hash element names
session identifiers
session IDs
session management
client-side vs. server-side storage
security aspects
common tasks
Perl, using
server-side, database-backed
session-based scripts
session_set_save_handler( ) (PHP)
2nd
sessions
logging
terminating
SET
calculations, using for
SET column type
renaming, column definition issues
SET columns
column definitions, adding
comparing in self-joins
definitions, obtaining
hashes, for testing legality of data
input values, validating
2nd
member lists, obtaining
SET values
stings, treatment as
sh
PATH environment variable, setting
shell scripting
shell scripts
Unix, writing in
Windows, writing in
shell scripts, invocation of mysql in
SHOW COLUMNS queries
ENUM columns, validation of input with query results
SET columns, validation of input with query results
SHOW COLUMNS statement
default values displayed, interpreting
ENUM column information, using to get
SET column information, using to get
table structure information, getting
APIs, using
table structure information, getting with
SHOW CREATE TABLE statement
2nd
3rd
checking available table types using
table structure information, getting with
SHOW DATABASES query
complete listing of databases, obtaining with
interpreting
SHOW DATABASES statement
testing for existence of a database, using for
SHOW INDEX statement
SHOW STATUS statement
MySQL servers, monitoring using
SHOW TABLE STATUS statement
2nd
SHOW TABLES queries
interpreting
SHOW TABLES query
complete listing of tables, obtaining with
SHOW TABLES statement
Java, issuing programatically using
SHOW VARIABLES statement
determining a serverÕs supported table types
MySQL servers, monitoring using
signed integers, pattern for matching
--silent option
SimpleServlet class
single page navigation indexes, generating from database content
single strings, representing as
single-pick form elements
creating from database content
types
single-pick list elements
functions and arguments
functions, constructing for
value lists and label hashes
single-row sequence generators
item tracking using
--skip-column-names (MySQL 3.22.20)
| (program indicator, Apache)
somedata.csv problem
solution
sorting
aliasing of expressions
APIs, using
ascending order
by calendar day
column aliases, using
columns, positional references for
on dates or times
by day of week
mapping first day from Sunday to Monday
DAYOFYEAR( ), problems using
default sort direction
descending order
2nd
displaying as strings values sorted as numbers
expression results, using
lexical vs. numerical order
MIN( ), MAX( ), and case sensitivity
multiple column sorts
mixed-order sorting
NULL values and
of result sets
on single-columns
string sorts and case sensitivity
on table subsets
by time of day
on unselected values
sorting operations
SOURCE
2nd
source loops
special characters
database, table, and column names
encoding in web output
APIs, using
encoding interactions
HTML special characters
URL special characters
in strings
including in queries
Spreadsheet::ParseExcel::Simple module
Spreadsheet::WriteExcel::FromDB module
Spreadsheet::WriteExcel::Simple module
SQL
date conversion using
pattern matching
vs. FULLTEXT searching
NULL values and
regular expressions, contrasted with
reformatting of data in temporary tables
statements
variables
calculation results, storing in
non MySQL database engines, and
for numbering query output lines
sql_quote( ) (PHP MySQL_Access class)
ssh, using for dumps between servers
standard deviation
calculation using aggregate functions
uses
start_form( ) (Perl)
start_multipart_form( ) (Perl)
startup files
state_pager1.pl
2nd
state_pager2.pl
statement recall utility
Windows systems
statement terminator, mysql
statement terminators
APIs and
statements
types of
2nd
statistical techniques
aggregate functions in the calculation of statistical data
calculating descriptive statistics
correlation coefficients, calculating
counting missing values (NULLs)
frequency distributions, generating
uses for
linear regressions, calculating
median, calculating
mode, calculating
per-group descriptive statistics, calculating
random number generation
randomizing a set of rows
assigning ranks
selecting randomly from a set of rows
STATUS
STATUS command
STD( )
STDDEV( )
store_image.pl
2nd
image storage configuration for database or filesystem
STRCMP( )
string functions
extraction of date and time values using
string( ) (Perl)
strings
calculating one date from another using substring replacement
case sensitivity
MIN( ) and MAX( )
case sensitivity in comparisons, controlling
case sensitivity, managing in comparisons
combining in larger strings
equality, testing for
forcing interpretation as temporal values
numbers, conversion to
pattern matching
[See pattern matching]
relative ordering
string types
substrings, extraction
substrings, matching to
trailing spaces, preserving
strip_slash_helper( ) (PHP)
subselect queries
converting to join operations
SUBSTRING( )
SUBSTRING_INDEX( )
SUBSTRING_INDEX( ), for breaking apart strings at delimiters
substrings, extraction from strings
suEXEC mechanism
SUM( )
strings, inapplicability to
summaries
averages
calculations, using APIs for
computed summaries
COUNT( )
counting summaries
date-based
distinct values, categorizing
determining whether values are unique
display order, controlling
getting distinct values without DISTINCT
duplicates, detecting with
2nd
duplicates, eliminating from
expression results, grouping by
finding smallest or largest values
multiple sets of values, handling
finding values associated with minimum and maximum values
using joins
MAX-CONCAT trick
two-query approach
grouping data by ranges
HAVING clauses
COUNT( ), using with
joins, producing with
LEFT JOINs and reference tables, creating with
LIMIT clauses and
master-detail summaries, producing
MIN( ) and MAX( )
missing values, incorporating
on non-categorical data
NULL values and
of per-group and overall summary values
ranges, defining
repetition, measuring in value sets
reports, generating
selection, groups with certain characteristics
subgroups, dividing into
sums
techniques
time-based
distinct values, categorizing
types of
using temporary tables and joins
sys.argv (Python)
sys.path variable
|
Main Menu
|
