Index: S

Book Home

Symbols & Numbers | 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

Index: S

--safe-recover option: 4.6.2. Repairing a Table

safe_mysqld command: 1.6. What You Get

2.2.1. Binary (Tarball) Distributions

2.2.3. Source Distributions

4.2.1. Unix/Linux

error logs and: 4.3. Logging

log rotation and: 4.3.4. Log Rotation

starting MySQL

on Mac OS X systems: 4.2.2. Mac OS X
on non-SVR4 Unix systems: 4.2.1.2. Other Unix

scalability and distributed application architecture: 8.1.2. Distributed Application Architecture

scalar variable types in PHP: 11.1.1. A Short Language Primer

scrollable result sets: 13.2.1. Queries and Result Sets

searching on text elements: 3.9.1. Full Text Searching

SECOND( ) function: 17.2.2. General Functions

second normal form (2NF): 7.2.4. Second Normal Form

7.2.7. More 2NF

SEC_TO_TIME( ) function: 17.2.2. General Functions

Secure Sockets Layer (SSL)

data transfer between web browsers/web servers: 11.7. Using the HTML <form> Environment
in MySQL 4.0: 6.2.3.2. Encryption
mysql_ssl_cipher( ): 19.2. Functions
mysql_ssl_clear( ): 19.2. Functions
mysql_ssl_set( ): 19.2. Functions

security: 6. Security

application security: 6.3. Application Security

client applications and: 6.3.2. Client Applications

automatic variable initialization, risks with: 11.4. Securing User Data

database security: 6.1. Database Security

privilege management: 6.1.2. Privilege Management
user management: 6.1.1. User Management

encrypting passwords: 11.7. Using the HTML <form> Environment

include file problems: 11.3.6. Include Files

system security: 6.2. System Security

for hardware: 6.2.2. Hardware Security
for networks: 6.2.3. Network Security
for operating systems: 6.2.1. Operating System Security

security libraries: 6.3.1.2. Resource protection

security tables, storing user privileges in: 6.1.2.2. The security tables

SELECT INTO OUTFILE statement: 6.1.2.1. GRANT and REVOKE

SELECT privilege: 6.1.2.1. GRANT and REVOKE

SELECT statement: 3.7. Queries

15.2. SQL Commands
aliasing and: 3.7.2. Aliasing
EXPLAIN SELECT command and: 5.2.2.2. EXPLAIN SELECT
functions in: 3.9.4. Functions
using with INSERT statement: 15.2. SQL Commands
joining tables: 3.7.1. Joins
limiting results: 3.7.4. Limiting Results
ordering/grouping results: 3.7.3. Ordering and Grouping
sending queries using static methods: 9.3.1. A Model for Relational Data
UNION clause and: 3.9.6. Unions

selectall_arrayref( ): 9.1.4. Introducing Bind Variables and Optimizations

SelectResource.properties file: 13.1.3.1. Properties files

semicolon (;)

comments in configuration files: 4.1.2. File Content
statement termination character in PHP scripts: 11.1.1. A Short Language Primer

sequences, generating: 3.6.2. Sequence Generation

SERIALIZABLE transaction isolation level: 8.2.2.1. Transaction isolation levels

server instances and configuration files: 4.1.1. File Locations

server variables and $HTTP_SERVER_VARS array: 11.4. Securing User Data

servers

application

resource protection: 6.3.1.2. Resource protection
user management issues: 6.3.1.1. User management

backups: 4.4. Backup

log files: 4.3. Logging

performance tuning for: 5.3. Database Server Tuning

privileges that apply to: 6.1.2.1. GRANT and REVOKE

recovery

from backups: 4.5. Recovery
from crashes: 4.6. Table Maintenance and Crash Recovery

security issues for: 6.2.1. Operating System Security

starting

binary distributions: 2.2.1. Binary (Tarball) Distributions
source distributions: 2.2.3. Source Distributions
Windows distributions: 2.3. Windows Installation

startup/shutdown: 4.2. Server Startup and Shutdown

in Windows binary distribution: 2.3. Windows Installation

Services control panel: 2.3.2. Windows NT/2000 Startup

session variables and $HTTP_SESSION_VARS array: 11.4. Securing User Data

sessions library in PHP: 11.5. Managing Sessions

SESSION_USER( ) function: 17.2.2. General Functions

set( ) (Cache class): 9.3.2.9. The Cache class

SET data type: 3.4.4. Enumerations and Sets

16.4. Complex Data Types
19.1. Data Types

SET statement: 15.2. SQL Commands

updating tables: 3.6.3. Updates

--set-variable connect_timeout parameter: 11.3.2. Opening and Using a Database Connection

--set-variable max_allowed_packet=1M option: 4.1.2. File Content

setID( ) (Publisher class): 9.3.2. Implementing the Model

9.3.2.4. Getter/setter methods

setinputsizes( ) (MySQLdb module): 20.1.6. Cursor Methods

setName( ) (Publisher class): 9.3.2. Implementing the Model

9.3.2.4. Getter/setter methods

setoutputsize( ) (MySQLdb module): 20.1.6. Cursor Methods

setter/getter methods: 9.3.1. A Model for Relational Data

9.3.2.4. Getter/setter methods

shared libraries and user-defined functions: 14.1.3. Calling a UDF

shell-script commenting: 15.1.3. Comments

SHOW DATABASES command: 3.2. Database Creation

SHOW PROCESSES statement: 15.2. SQL Commands

SHOW PROCESSLIST statement: 6.1.2.1. GRANT and REVOKE

SHOW statements: 15.2. SQL Commands

SHOW TABLES statement: 3.3. Table Management

showerror( ): 11.3.5. Handling MySQL Errors

SHUTDOWN privilege: 6.1.2.1. GRANT and REVOKE

shutting down servers: 4.2. Server Startup and Shutdown

SIGN( ) function: 17.2.2. General Functions

SIN( ) function: 17.2.2. General Functions

--skip-locking option: 4.1.2. File Content

slash (/) division operator: 3.8. SQL Operators

17.1.2. Arithmetic Operators

slow query logs: 4.3.3. The Slow Query Log

SMALLINT data type: 16.1. Numeric Data Types

19.1. Data Types

socketTimeout property (twz JDBC driver): 13.1.2.2. Driver manager connectivity

Solaris systems, installing MySQL on: 2. Installation

SomeDataSourceClass class: 13.1.2.1. Data source connectivity

sorting

custom character sets and: 14.2. Alternative Character Sets
localized: 3.7.3.2. Localized sorting

sort_order array

complex character sets: 14.2.2. Complex Character Sets
simple character sets: 14.2.1. Simple Character Sets

SOUNDEX( ) function: 3.9.4.2. String functions

17.2.2. General Functions

source code, obtaining/compiling: 11.2.1. Getting Started Under Unix

source distributions: 2.1. Preparation

installing, using tar and gunzip utilities: 2.2.3. Source Distributions
naming conventions for: 2.2.3. Source Distributions

SPACE( ) function: 17.2.2. General Functions

sprintf( ): 12.2.2. Quote Retrieval

SQL

case sensitivity issues: 3.1.2. The Design of SQL

15.1. Basic Syntax

command syntax for MySQL: 15. SQL Syntax for MySQL

comments used in: 15.1.3. Comments

data types: 3.4. MySQL Data Types

design of: 3.1.2. The Design of SQL

dynamic: 13.3.2. Processing Dynamic SQL

functions: 3.9.4. Functions

17.2. Functions

history of: 3.1.1. The SQL Story

identifiers used in: 15.1.2. Identifiers

indexing support: 3.4.2. Character Types

3.5. Indexing

literals used in: 15.1.1. Literals

methods for building and executing: 9.3.2.2. Methods that build and execute SQL

operators: 3.8. SQL Operators

17.1. Operators

parameterized: 10.1.3. Parameterized SQL

queries: 3.1. SQL Basics

3.1.2. The Design of SQL
performance tuning for: 5.2.2. SQL Query Tuning

sending to MySQL: 3.1.3. Sending SQL to MySQL

SQL89 standard: 3.1.1. The SQL Story

SQL_BIG_SELECTS option (SET statement): 15.2. SQL Commands

SQL_BIG_TABLES option (SET statement): 15.2. SQL Commands

SQLException class: 13.2.2. Error Handling and Clean Up

SQL_LOG_OFF option (SET statement): 15.2. SQL Commands

SQL_SELECT_LIMIT option (SET statement): 15.2. SQL Commands

SQL_UPDATE_LOG option (SET statement): 15.2. SQL Commands

SQRT( ) function: 17.2.2. General Functions

SSL (Secure Sockets Layer)

data transfer between web browsers/web servers: 11.7. Using the HTML <form> Environment
in MySQL 4.0: 6.2.3.2. Encryption
mysql_ssl_cipher( ): 19.2. Functions
mysql_ssl_clear( ): 19.2. Functions
mysql_ssl_set( ): 19.2. Functions

staging environment: 6.1.1. User Management

standard functions (UDFs): 14.1.1. Standard Functions

start_html( ): 9.2.1. Introduction to Perl CGI

starting servers: 4.2. Server Startup and Shutdown

startup directories for Mac OS X: 4.2.2. Mac OS X

StartupParameters.plist file: 4.2.2. Mac OS X

Statement class: 13.2. Simple Database Access

13.3. Dynamic Database Access

statement handles: 9.1.1. Basic Perl Example

bind_where( ) and: 9.3.2. Implementing the Model

9.3.2.3. Methods that handle WHERE clauses

error handling and attributes: 9.1.3. Error Handling and Attributes

retrieving all rows from: 9.1.4. Introducing Bind Variables and Optimizations

static-linked PHP modules: 11.2.1.1. Installation problems

static methods: 9.3.1. A Model for Relational Data

STD( ) function: 17.2.1. Aggregate Functions

STDDEV( ) function: 17.2.1. Aggregate Functions

stdio.h header file: 12.1. API Overview

$sth variable: 9.1.1. Basic Perl Example

stopwords in full text searching: 3.9.1.2. Relevance values

storage space requirements of data types: 3.4.2. Character Types

stored procedures in MySQL: 8.1.1.1. Application logic

STRAIGHT_JOIN keyword (SELECT statement): 15.2. SQL Commands

STRCMP( ) function: 17.2.2. General Functions

string collating routines: 14.2. Alternative Character Sets

creating character sets with: 14.2.2. Complex Character Sets

STRING data type, return value for user-defined functions: 14.1.1.2. The main routine

string data types: 16.2. String Data Types

string functions: 3.9.4.2. String functions

string literals (SQL): 15.1.1. Literals

STRING_RESULT type: 14.1.1.2. The main routine

SUBDATE( ) function: 17.2.2. General Functions

substr( ): 11.4. Securing User Data

SUBSTRING( ) function: 17.2.2. General Functions

SUBSTRING_INDEX( ) function: 17.2.2. General Functions

subtraction operator (-): 3.8. SQL Operators

17.1.2. Arithmetic Operators

SUM( ) function: 17.2.1. Aggregate Functions

support-files directory: 4.2.1.1. SVR4

log rotation and: 4.3.4. Log Rotation

SVR4 systems, server startup/shutdown for: 4.2.1.1. SVR4

switch conditional in PHP: 11.1.1. A Short Language Primer

symbolic links, creating: 2.2.1. Binary (Tarball) Distributions

syntaxes, nonstandard: 3.6.1. Inserts

SYSDATE( ) function: 17.2.2. General Functions

system join type: 5.2.2.2. EXPLAIN SELECT

system locking, disabling: 4.1.2. File Content

system security: 6.2. System Security

/System/Library/StartupItems directory: 4.2.2. Mac OS X

SYSTEM_USER( ) function: 17.2.2. General Functions

Symbols & Numbers | 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