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]

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)