Book Home

Book TitleSearch this book

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
Library Navigation Links

Copyright © 2003 O'Reilly & Associates, Inc. All Rights Reserved.