Index S

only for RuBoard - do not distribute or recompile

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

only for RuBoard - do not distribute or recompile