S

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]

S
-s (silent) option
     controlling verbosity level of output
-s (socket file) option
\s (whitespace) Perl pattern element
%s format sequence
sample tables, creating
saveOnRestart attribute (JDBC Manager element)
SCALE attribute
scale Ruby member name
screen output
script program, saving terminal log sessions
SCRIPT_NAME member
script_name( ) function (Perl)
ScriptAlias directive
scripts, creating from previous statements
scrolling lists (HTML) 2nd
scrolling_list( ) function (JSP)
scrolling_list( ) function (Perl)
SDK (Java Software Development Kit)
SDK (software development kit) 2nd
     Tomcat, setting up
searches (web-based)
SEC_TO_TIME( ) function 2nd 3rd
SECOND( ) function 2nd
sed program
     specifying column delimiters with
SELECT CURRENT_USER( ) statement
SELECT DATABASE( ) statement
SELECT DISTINCT statement 2nd
     eliminating duplicates from self-join results
<select> HTML tag 2nd
SELECT LAST_INSERT_ID( ) statement
SELECT statement
     @@sql_mode statement
     calculator, using as
     cloning tables
     determining whether a statement produced a result set
     duplicates, dealing with
     exporting query results
     fetchrow_array( ) and
     hit counters and
     INFORMATION_SCHEMA and
     Perl
         placeholders and
     PHP
     Python 2nd
     result sets, combining in single queries
     retrieving images or binary data
     Ruby
     saving query results in tables with
     selecting data from tables
     sorting query results with
     user-defined variables and
     using * 2nd 3rd
SELECT USER( ) statement
SELECT VERSION( ) statement
select_all method (Ruby)
select_one method (Ruby)
SELECT_VERSION( ) function
selectall_arrayref( ) method (Perl) 2nd 3rd
selectall_hashref( ) method (Perl) 2nd
selectcol_arrayref( ) method (Perl) 2nd
selectrow_array( ) method (Perl) 2nd
selectrow_arrayref( ) method (Perl)
selectrow_hashrow( ) method (Perl)
self-join
     cumulative sums and running averages, finding
     duplicates, eliminating
     successive-row differences, calculating
semicolon (;)
     compound-statement objects and
     files, reading statements from
     PERL5LIB library files, installing
     terminating statements 2nd 3rd
         APIs and
     writing to option files
sequences
     AUTO_INCREMENT columns, creating multiple
     data types, choosing for
     extending ranges of columns
     generating columns/values
     generators as counters
     multiple simultaneous AUTO_INCREMENT values, managing
     query output, numbering
     relating tables, using AUTO_INCREMENT
     renumbering existing
     repeating
     retrieving values
     reusing values at top of
     row deletions, effects of
     starting at a particular value
     unsequenced tables
sequencing
     renumbering in a particular order
server (MySQL)
     API architecture
     connecting 2nd
     metadata, getting
     monitoring
     statements, sending
     using different simultaneously
     versions, writing applications that adapt to
server (mysqld)
server Tomcat directory
server-side session storage
server-side validation
server.xml configuration file 2nd
servers (MySQL)
     transactional storage engine
servlet container
servlets
servlets (Java)
$_SESSION array (PHP)
SESSION modifiers
session object (JSP)
session scope (JSP)
session tables
session_destroy( ) function (PHP)
session_key (Ruby CGI object)
session_name( ) function (PHP)
session_register( ) function (PHP)
session_start( ) function (PHP)
session_unregister( ) function (PHP)
session_write_close( ) function (PHP)
sessions
     management issues
     Perl applications and
     PHP applications
     Ruby applications
     Tomcat and
sessions, logging interactive
SET clause
SET NAMES method, selecting character sets
SET statement 2nd
     column information, getting
SET string type 2nd
     table metadata, using to validate data
setAttribute( ) method (JSP)
setFetchMode( ) method (PHP)
setInt( ) method (Java)
setString( ) method (Java)
sh shell 2nd
shared Tomcat directory
shell commands
shell scripts
SHOW CHARACTER SET statement
SHOW COLLATION statement
SHOW COLUMNS statement
     table structure, using
SHOW CREATE TABLE statement 2nd 3rd
SHOW ENGINES statement 2nd
SHOW GLOBAL STATUS statement
SHOW statement
SHOW STATUS statement
     monitoring the MySQL server
SHOW TABLE STATUS statement 2nd
SHOW VARIABLES statement
     monitoring the MySQL server
SHOW WARNINGS statement
--silent option
     controlling verbosity level of output
single-byte characters
sjis (Japanese) strings
skip-auto-rehash option
--skip-auto-rehash option
--skip-column-names option 2nd
     numbering query output lines
     shell scripts and
SMALLINT data type
Smarty template package 2nd 3rd
     list generation
     paragraph generation
     table generation
socket file pathnames
--socket option
software development kit (SDK) 2nd
     Tomcat, setting up
software, obtaining
sorting query results
     calendar days, sorting by
     case-sensitivity, controlling
     date-based
     day of the week
     dotted-quad IP values in numeric order
     ENUM values
     expression, using
     fixed-length substrings
     floating values
     "hidden" values
     hostnames, sorting in domain order
     substrings of column values, using
     time of day
     user-defined orders
     variable-length substrings
SOURCE command
spans (dates and times)
special characters 2nd
     identifiers, handling in
     Java
     Ruby DBI
     web pages, encoding in
split( ) function (Perl)
sports teams, computing team standings
Spreadsheet::ParseExcel::Simple module (Perl)
Spreadsheet::WriteExcel::Simple module (Perl)
SQL (Structured Query Language)
    statements [See statements]
SQL injection attacks 2nd 3rd
SQL mode
     strict 2nd 3rd
SQL patterns
<sql:param> JSTL database tag
<sql:query> JSTL database tag
<sql:setDataSource> JSTL database tag 2nd
<sql:update> JSTL database tag
sql_type Ruby member name
SQLException objects
SQLSTATE error code 2nd 3rd
square brackets ([ ])
     pattern matching
     Perl pattern elements
     writing groupname values
-ss (--skip-column-names) option
ssh program
standard deviation
START TRANSACTION statement 2nd
start_form( ) method (Perl)
start_html( ) CGI.pm module (Perl)
start_multipart_form( ) function (Perl)
STARTING BY subclause
statement terminator (;)
statements (SQL)
     canceling
     exporting tables contents as
     files, reading from
     issuing
     issuing and retrieving results
     obtaining the number of rows affected by
     one-liners, entering
     other programs, reading statements from
     previously executed, creating scripts from
     repeating and editing
     result set metadata, determining whether produced
     special characters and NULL values, handling
         identifiers and
     transactions, performing
     user-defined variables, using
static keyword (Java)
statistical techniques
     assigning ranks
     descriptive statistics
         per-group
     frequency distributions
     linear regressions or correlation coefficients, calculating
     missing values, counting
     random numbers
     rows, randomizing sets of
     selecting random items from rows
STD( ) function
STDDEV_SAMP( ) function
storage engines
storage engines (tables)
storage engines (transactional)
<Store> element (JDBC)
stored routines 2nd
     returning multiple values
STR_TO_DATE⁠(⁠ ⁠ ⁠) function 2nd
strict keyword (Perl)
strict SQL mode 2nd 3rd
strings
     breaking apart or combining
     case-sensitivity, controlling
     changing character sets/collations
     client connection character sets, setting
     collations/character sets, checking
     data types
     duplicate identification and case-sensitivity
     FULLTEXT searches
         phrase searches, performing
         search words, requiring/excluding
         short words, using with
     lettercase, converting
         "stubborn"
     literals, writing
     pattern matching
         case-sensitivity, controlling
         regular expressions and
     properties
     substrings, searching for
Structured Query Language [See SQL]
structures of datafiles, manipulating
"stubborn" strings
sub( ) method (Python)
subprotocol designator
subqueries
substitution Perl pattern matches (/.../.../)
SUBSTRING( ) function
     variable-length substrings, sorting by
SUBSTRING_INDEX( ) function 2nd
     hostnames, sorting in domain order with
substrings
     sorting by
successive-row differences, calculating
suEXEC (Apache)
SUM( ) function 2nd
     IFNULL( ) function and
     subgroups, dividing into
     summarizing with
summaries, generating
     case-sensitivity for MIN( ) and MAX( )
     COUNT( ) function and
     date-based
     display order, controlling
     duplicates, eliminating with DISTINCT
     expression results, grouping by
     finding smallest/largest values
     master-detail lists, producing
     MIN( ) and MAX( ) functions
     NULL values and
     per-group and overall values, working with
     reports
     selecting groups with certain characteristics
     subgroups, dividing into
     SUM and AVG( ) functions
     uniques values, using COUNT( ) to determine
     values associated with minimum/maximum values, finding
summaries, grouping
     categorizing noncategorical data
summarizing TIME values 2nd
SUPER privilege
sys.exit( ) method (Python)
sys.path variable (Python)