Index: S (MySQL & mSQL)
Symbols
| 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
- \s command: 17.1. MySQL Utilities
 
- safe_mysqld script: 4.3. Running MySQL
 
- scalability: 8.4. The Three-tier Architecture
 
- scalar reference: 10.1. DBI
 
- scripts
 
  
  
  - for CD database: 2.4. Physical Database Design
 
  
  
  
  - mSQL installation setup: 3.2. mSQL
 
  
  
  
  - mSQL server process: 5.4. Running mSQL
 
  
  
  
  - restarting the msql2d daemon: 5.4. Running mSQL
 
  
 
- search engines, querying: 9.4.1. State Retention
 
- SECOND( ) function: 15.1. MySQL SQL
 
- second normal form (see normalization, second normal form)
 
- SEC_TO_TIME( ) function: 15.1. MySQL SQL
 
- security
 
  
  
  - CGI considerations: 9.4.2. Security
 
  
  
  
  - MySQL: 4.4.3. Security
 
  
 
- seek( ) method: 11.2.1. MySQL Statement Handlers
 
- select db( ) method: 13.1. The Two APIs
 
- SELECT statement: 15.1. MySQL SQL
 
  - 15.1. MySQL SQL
 
  - 15.2. mSQL SQL
 
 
- selectdb function: 21.3. 
Msql.pm API
 
- SelectResource.properties file: 14.1.2. Maintaining Portability Using Properties Files
 
- sequences: 5.6.2.5. Miscellaneous
 
  - 6.5. Sequences and Auto-Incrementing
 
 
- Server Side Includes (SSI): 12.1. Alternatives for Dynamic Content on the Web
 
- server-side interpreter: 12.1. Alternatives for Dynamic Content on the Web
 
- server statistics: 5.5.1.4. 
Server status
 
- Server version: 4.4.1.4. Server status
 
- server-wide my.cnf file: 16.1.3. The MySQL Configuration File
 
- servertype attribute: 10.1. DBI
 
- SESSION_USER( ) function: 15.1. MySQL SQL
 
- SET datatype: 6.3.4. Enumerations and Sets
 
  - 15.1. MySQL SQL
 
 
- SET statement: 15.1. MySQL SQL
 
- setArray( ) method: 22. JDBC Reference
 
- setAsciiStream( ) method: 22. JDBC Reference
 
- setAutoCommit( ) method: 22. JDBC Reference
 
- setBigDecimal( ) method: 22. JDBC Reference
 
- setBinaryStream( ) method: 22. JDBC Reference
 
- setBlob( ) method: 22. JDBC Reference
 
- setBoolean( ) method: 22. JDBC Reference
 
- setByte( ) method: 22. JDBC Reference
 
- setBytes( ) method: 22. JDBC Reference
 
- setCatalog( ) method: 22. JDBC Reference
 
- setCharacterStream( ) method: 22. JDBC Reference
 
- setClob( ) method: 22. JDBC Reference
 
- setConcurrency( ) method: 22. JDBC Reference
 
- setContentType( ) function: 18.2. Lite
 
  - 18.2. Lite
 
 
- setcookie( ) function: 18.1. PHP
 
  - 18.1. PHP
 
 
- setCursorName( ) method: 22. JDBC Reference
 
- setDate( ) method: 22. JDBC Reference
 
  - 22. JDBC Reference
 
 
- setDouble( ) method: 22. JDBC Reference
 
- seterrorreporting( ) function: 18.1. PHP
 
  - 18.1. PHP
 
 
- setEscapeProcessing( ) method: 22. JDBC Reference
 
- setFetchDirection( ) method: 22. JDBC Reference
 
- setFetchDirection() method: 22. JDBC Reference
 
- setFetchSize( ) method: 22. JDBC Reference
 
- setFetchSize() method: 22. JDBC Reference
 
- setFloat( ) method: 22. JDBC Reference
 
- setInt( ) method: 22. JDBC Reference
 
- setlogging( ) function: 18.1. PHP
 
  - 18.1. PHP
 
 
- setLoginTimeout( ) method: 22. JDBC Reference
 
- setLogStream( ) method: 22. JDBC Reference
 
- setLong( ) method: 22. JDBC Reference
 
- setMaxFieldize( ) method: 22. JDBC Reference
 
- setMaxRows( ) method: 22. JDBC Reference
 
- setMonth( ) method: 22. JDBC Reference
 
- setNanos( ) method: 22. JDBC Reference
 
- setNull( ) method: 22. JDBC Reference
 
- setObject( ) method: 22. JDBC Reference
 
- setReadOnly( ) method: 22. JDBC Reference
 
- setRef( ) method: 22. JDBC Reference
 
- setShort( ) method: 22. JDBC Reference
 
- setshowinfo( ) function: 18.1. PHP
 
  - 18.1. PHP
 
 
- setString( ) method: 22. JDBC Reference
 
- setTime( ) method: 22. JDBC Reference
 
  - 22. JDBC Reference
 
  - 22. JDBC Reference
 
 
- setTimestamp( ) method: 22. JDBC Reference
 
- setTransactionIsolation( ) method: 22. JDBC Reference
 
- settype( ) function: 18.1. PHP
 
  - 18.1. PHP
 
 
- setTypeMap( ) method: 22. JDBC Reference
 
- setUnicodeStream( ): 22. JDBC Reference
 
- setup script, mSQL: 3.2. mSQL
 
- setYear( ) method: 22. JDBC Reference
 
- shell script: 12.2.2. Installation
 
- shl( ) function: 18.1. PHP
 
  - 18.1. PHP
 
 
- SHOW PROCESSES statement: 15.1. MySQL SQL
 
- SHOW statement: 15.1. MySQL SQL
 
- shr( ) function: 18.1. PHP
 
  - 18.1. PHP
 
 
- shutdown command: 4.4.1.6. Command line options for mysqladmin
 
  - 17.1. MySQL Utilities
 
  - 17.2. mSQL Utilities
 
 
- shutdown function: 21.3. 
Msql.pm API
 
- SIGN( ) function: 15.1. MySQL SQL
 
- SIN( ) function: 15.1. MySQL SQL
 
- single-threaded server: 5.1. Design
 
- site.mm file: 3.2. mSQL
 
- sleep( ) function: 18.1. PHP
 
  - 18.1. PHP
 
  - 18.2. Lite
 
  - 18.2. Lite
 
 
- Sleep command: 4.4.1.4. Server status
 
- Slow queries, mySQL server status: 4.4.1.4. Server status
 
- SLQ2 standard: 6.6.1. Inserts
 
- SMALLINT datatype: 15.1. MySQL SQL
 
- Sock: 5.5.1.4. 
Server status
 
- sock function: 21.3. 
Msql.pm API
 
- sort( ) function: 18.1. PHP
 
  - 18.1. PHP
 
 
- sortbuffer option: 16.1.2. Command line variables
 
- sort_key_blocks option: 16.1.2. Command line variables
 
- SOUNDEX( ) function: 15.1. MySQL SQL
 
- SPACE( ) function: 15.1. MySQL SQL
 
- special characters
 
  
  
  - for comments: 16.1.3. The MySQL Configuration File
 
  
  
  
  - in URLs: 10.3. Msql.pm
 
  
  
  
  - with WHERE statement construct: 15.1. MySQL SQL
 
    - 15.2. mSQL SQL
 
  
 
  
 
- split( ) function: 18.2. Lite
 
  - 18.2. Lite
 
 
- sprintf( ) function: 18.1. PHP
 
  - 18.1. PHP
 
 
- SQL: 1.2. What Is a Relational Database?
 
  
  
  - advantages: 6. SQL According to MySQL and mSQL
 
  
  
  
  - datatypes: 6.3. SQL Datatypes
 
  
  
  
  - design of: 6.1.2. The Design of SQL
 
  
  
  
  - history: 6.1.1. The SQL Story
 
  
  
  
  - index creation: 6.4. Indices
 
  
  
  
  - mSQL reference: 15.2. mSQL SQL
 
  
  
  
  - MySQL reference: 15.1. MySQL SQL
 
  
  
  
  - naming rules: 2.4. Physical Database Design
 
  
  
  
  - queries: 6.1.2. The Design of SQL
 
  
  
  
  - structure: 6.1. SQL Basics
 
  
 
- SQL92 (ANSI SQL): 1.2. What Is a Relational Database?
 
- SQL3 array objects: 22. JDBC Reference
 
- SQL2 standard: 1.2. What Is a Relational Database?
 
  - 6.1.1. The SQL Story
 
  - 7.4. GNU SQL
 
 
- SQLBase API: 5.6.2.4. 
Programming interfaces
 
- Sqlscreens utility: 4.5.2.4. Programming interfaces
 
- sqrt( ) program function: 18.1. PHP
 
  - 18.1. PHP
 
 
- Sqs: 5.6.2.5. Miscellaneous
 
- Squile: 4.5.2.4. Programming interfaces
 
- srand( ) function: 18.1. PHP
 
  - 18.1. PHP
 
 
- src/w3-msql directory, shell script: 12.2.2. Installation
 
- SSL: 5.6.2.5. Miscellaneous
 
- startup scripts: 4.3. Running MySQL
 
- stat( ) function: 18.2. Lite
 
  - 18.2. Lite
 
 
- state function: 21.2. 
DBI.pm API
 
- state retention: 9.4.1. State Retention
 
- Statement class: 14.2. Simple Database Access
 
  - 14.3. Dynamic Database Access
 
 
- statement handlers: 11.2.1. MySQL Statement Handlers
 
- Statement interface: 22. JDBC Reference
 
- Statement::affectedrows function: 21.4. 
Mysql.pm API
 
- Statement::as_string function: 21.3. 
Msql.pm API
 
- Statement::dataseek function: 21.3. 
Msql.pm API
 
  - 21.3. 
Msql.pm API
 
  - 21.3. 
Msql.pm API
 
 
- Statement::fetchcol function: 21.3. 
Msql.pm API
 
- Statement::fetchhash function: 21.3. 
Msql.pm API
 
- Statement::fetchrow function: 21.3. 
Msql.pm API
 
- statement_handle: 20.1. Module: MySQL
 
- Statement::info function: 21.4. 
Mysql.pm API
 
- Statement::insertid function: 21.4. 
Mysql.pm API
 
- Statement::isblob function: 21.4. 
Mysql.pm API
 
- Statement::isnotnull function: 21.3. 
Msql.pm API
 
- Statement::isnum function: 21.3. 
Msql.pm API
 
- Statement::isprikey function: 21.3. 
Msql.pm API
 
- Statement::length function: 21.3. 
Msql.pm API
 
- Statement::listindices: 21.3. 
Msql.pm API
 
- Statement::maxlength function: 21.3. 
Msql.pm API
 
- Statement::name function: 21.3. 
Msql.pm API
 
- Statement::numfields function: 21.3. 
Msql.pm API
 
- Statement::numrows function: 21.3. 
Msql.pm API
 
- Statement::table function: 21.3. 
Msql.pm API
 
- Statement::type function: 21.3. 
Msql.pm API
 
- Statistics command: 4.4.1.4. Server status
 
- statistics, mSQL: 5.5.1.4. 
Server status
 
- stats command: 17.2. mSQL Utilities
 
- status command: 4.4.1.6. Command line options for mysqladmin
 
  - 17.1. MySQL Utilities
 
  - 17.1. MySQL Utilities
 
 
- STD( ) function: 15.1. MySQL SQL
 
- STDDEV( ) function: 15.1. MySQL SQL
 
- Stonebreaker, Michael: 7.3. PostgreSQL
 
- stored procedures: 7.2.3. Stored Procedures
 
- strchr( ) function: 18.1. PHP
 
  - 18.1. PHP
 
 
- STRCMP( ) function: 15.1. MySQL SQL
 
- strftime( ) function: 18.2. Lite
 
  - 18.2. Lite
 
 
- stripslashes( ) function: 18.1. PHP
 
  - 18.1. PHP
 
 
- strlen( ) function: 18.1. PHP
 
  - 18.1. PHP
 
 
- strrchr( ) function: 18.1. PHP
 
  - 18.1. PHP
 
 
- strstr( ) function: 18.1. PHP
 
- strtok( ) function: 18.1. PHP
 
  - 18.1. PHP
 
 
- strtolower( ) function: 18.1. PHP
 
  - 18.1. PHP
 
 
- strtoupper( ) function: 18.1. PHP
 
  - 18.1. PHP
 
 
- strtr( ) function: 18.1. PHP
 
  - 18.1. PHP
 
 
- Struct interface: 22. JDBC Reference
 
- strval( ) function: 18.1. PHP
 
  - 18.1. PHP
 
 
- sub( ) function: 18.2. Lite
 
  - 18.2. Lite
 
 
- subselects: 7.2.4. 
Subselects
 
- substr( ) function: 18.1. PHP
 
  - 18.1. PHP
 
  - 18.2. Lite
 
  - 18.2. Lite
 
 
- SUBSTRING( ) function: 15.1. MySQL SQL
 
- SUBSTRING() function: 15.1. MySQL SQL
 
- SUBSTRING_INDEX( ) function: 15.1. MySQL SQL
 
- SUM( ) function: 15.1. MySQL SQL
 
- support utilities: 4.5. MySQL Utilities
 
- Sybase, proprietary APIs: 14. Java and JDBC
 
- symlink( ) function: 18.1. PHP
 
  - 18.1. PHP
 
  - 18.2. Lite
 
  - 18.2. Lite
 
 
- SYSDATE( ) function: 15.1. MySQL SQL
 
- syslog( ) function: 18.1. PHP
 
  - 18.1. PHP
 
 
- system( ) function: 18.1. PHP
 
  - 18.1. PHP
 
  - 18.2. Lite
 
  - 18.2. Lite
 
 
- system variables, mSQL: 6.8.2. mSQL Features
 
- SYSTEM_USER( ) function: 15.1. MySQL SQL
 
Symbols
| 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
Copyright © 2001
O'Reilly & Associates, Inc.
All Rights Reserved.