Managing and Using MySQL, 2nd Edition

[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

 --safe-recover option

 safe_mysqld command , 2nd  , 3rd

 error logs and

 log rotation and

starting MySQL

 on non-SVR4 Unix systems

 scalability and distributed application architecture

 scalar variable types in PHP

 scrollable result sets

 searching on text elements

 SEC_TO_TIME() function

 second normal form (2NF) , 2nd

 SECOND() function

Secure Sockets Layer (SSL)

 data transfer between web browsers/web servers

 in MySQL 4.0

 mysql_ssl_cipher()

 mysql_ssl_clear()

 mysql_ssl_set()

 security

application security

 client applications and

 automatic variable initialization, risks with

database security

 user management

 encrypting passwords

 include file problems

system security

 for operating systems

 security libraries

 security tables, storing user privileges in

 SELECT INTO OUTFILE statement

 SELECT privilege

 SELECT statement , 2nd

 aliasing and

 EXPLAIN SELECT command and

 functions in

 using with INSERT statement

 joining tables

 limiting results

 ordering/grouping results

 sending queries using static methods

 UNION clause and

 selectall_arrayref()

 SelectResource.properties file

semicolon (;)

 comments in configuration files

 statement termination character in PHP scripts

 sequences, generating

 SERIALIZABLE transaction isolation level

 server instances and configuration files

 server variables and $HTTP_SERVER_VARS array

servers

application

 user management issues

 backups

 log files

 performance tuning for

 privileges that apply to

recovery

 from crashes

 security issues for

starting

 Windows distributions

 startup/shutdown

 in Windows binary distribution

 Services control panel

 session variables and $HTTP_SESSION_VARS array

 SESSION_USER() function

 sessions library in PHP

 SET data type , 2nd  , 3rd

 SET statement

 updating tables

 set() (Cache class)

 --set-variable connect_timeout parameter

 --set-variable max_allowed_packet=1M option

 setID() (Publisher class) , 2nd

 setinputsizes() (MySQLdb module)

 setName() (Publisher class)

 setoutputsize() (MySQLdb module)

 setter/getter methods

 shared libraries and user-defined functions

 shell-script commenting

 SHOW DATABASES command

 SHOW PROCESSES statement

 SHOW PROCESSLIST statement

 SHOW statements

 SHOW TABLES statement

 showerror()

 SHUTDOWN privilege

 shutting down servers

 SIGN() function

 SIN() function

 --skip-locking option

 slash (/) division operator , 2nd

 slow query logs

 SMALLINT data type , 2nd

 socketTimeout property (twz JDBC driver)

 Solaris systems, installing MySQL on

 SomeDataSourceClass class

sort_order array

 complex character sets

 simple character sets

sorting

 custom character sets and

 localized

 SOUNDEX() function , 2nd

 source code, obtaining/compiling

 source distributions

 installing, using tar and gunzip utilities

 naming conventions for

 SPACE() function

 sprintf()

SQL

 case sensitivity issues , 2nd

 command syntax for MySQL

 comments used in

 data types

 design of

 dynamic

 functions , 2nd

 history of

 identifiers used in

 indexing support , 2nd

 literals used in

 methods for building and executing

 operators , 2nd

 parameterized

queries

 performance tuning for

 sending to MySQL

 SQL_BIG_SELECTS option (SET statement)

 SQL_BIG_TABLES option (SET statement)

 SQL_LOG_OFF option (SET statement)

 SQL_SELECT_LIMIT option (SET statement)

 SQL_UPDATE_LOG option (SET statement)

 SQL2 standard , 2nd

 SQL3 standard

 SQL89 standard

 SQL92 standard

 SQLException class

 SQRT() function

SSL (Secure Sockets Layer)

 data transfer between web browsers/web servers

 in MySQL 4.0

 mysql_ssl_cipher()

 mysql_ssl_clear()

 mysql_ssl_set()

 staging environment

 standard functions (UDFs)

 start_html()

 starting servers

 startup directories for Mac OS X

 StartupParameters.plist file

 Statement class , 2nd

 statement handles

 bind_where() and

 error handling and attributes

 retrieving all rows from

 static methods

 static-linked PHP modules

 STD() function

 STDDEV() function

 stdio.h header file

 $sth variable

 stopwords in full text searching

 storage space requirements of data types

 stored procedures in MySQL

 STRAIGHT_JOIN keyword (SELECT statement)

 STRCMP() function

 string collating routines

 creating character sets with

 STRING data type, return value for user-defined functions

 string data types

 string functions

 string literals (SQL)

 STRING_RESULT type

 SUBDATE() function

 substr()

 SUBSTRING() function

 SUBSTRING_INDEX() function

 subtraction operator (-) , 2nd

 SUM() function

 support-files directory

 log rotation and

 SVR4 systems, server startup/shutdown for

 switch conditional in PHP

 symbolic links, creating

 syntaxes, nonstandard

 SYSDATE() function

 system join type

 system locking, disabling

 system security

 /System/Library/StartupItems directory

 SYSTEM_USER() function