Index S

[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]

schema
       defined  
scope columns
       columns_priv tables  
       db tables  
       host tables  
       tables_priv tables  
        user tables  
scripts directory  
searching
       full-text searching
               boolean full-text search   2nd   3rd   4th   5th  
       MyISAM tables
               full-text searching   2nd   3rd   4th   5th   6th  
second normal form (2NF)   2nd   3rd   4th   5th  
secure connection columns
       user tables  
Secure Sockets Layer (SSL)   2nd  
security
       accounts
               anonymous accounts, deleting   2nd   3rd  
               dangerous privileges   2nd  
               encrypted passwords   2nd  
               root passwords  
       installation files
               access and privileges   2nd   3rd  
               application-level error checking   2nd  
               do's and don'ts  
               filtered data   2nd  
               physical security   2nd  
               SSL (Secure Sockets Layer)   2nd  
       privilege systems  
               global privileges  
               server connections   2nd  
       replication systems   2nd  
SELECT privilege  
SELECT statement
       aliases   2nd   3rd   4th   5th  
       columns   2nd   3rd  
       databases   2nd   3rd   4th  
       DISTINCT clause   2nd   3rd   4th   5th  
       GROUP BY clause   2nd   3rd   4th  
       HAVING clause   2nd   3rd  
       LIMIT clause   2nd   3rd  
       ORDER BY clause   2nd   3rd  
       overview  
       simple query example   2nd  
       table creation  
       tables   2nd   3rd   4th  
       WHERE clause   2nd   3rd   4th   5th   6th  
select_type option
       EXPLAIN command  
selecting
       databases
               use statement   2nd  
       rows   2nd   3rd   4th   5th   6th  
self joins   2nd   3rd   4th  
semicolon (
       )  
serializable transaction isolation level  
server (MySQL)
       process information, viewing   2nd  
       starting up and shutting down   2nd   3rd  
       status of, viewing   2nd   3rd   4th  
server connections
       security   2nd  
server tuning (MySQL)
       optimization   2nd  
               parameters   2nd   3rd   4th   5th   6th  
               RAID utility  
               Solaris utility  
               speed, compiling and linking for   2nd   3rd  
servers
       master
               replicaion   2nd   3rd   4th   5th   6th   7th  
               replication  
       slaves
               replication   2nd   3rd   4th   5th   6th  
               starting   2nd   3rd  
Services window (Windows Administrative tools)  
SET column type  
SET command
       autocommit mode, disablging  
       log files, turning on  
SET statement
        variables , setting   2nd  
shared-memory -base- name options
       MySQL configuration  
SHOW command  
       database information, retrieving  
SHOW DATABASES privilege  
show processlist statement
       threads  
show variables statement  
SHUTDOWN privilege  
shutting down
       MySQL server   2nd   3rd  
single-column indexes  
single-value subqueries   2nd   3rd   4th   5th   6th  
Slashdot Web site  
slave servers
       replication   2nd   3rd   4th   5th   6th  
       starting   2nd   3rd  
Sleepycat Web site  
slow queries server value  
slow query log   2nd   3rd  
slow query logs  
SMALLINT integer column type  
snapshots, creating
       database replication   2nd   3rd   4th   5th   6th  
socket options
       MySQL configuration  
Solaris utility
       MySQL server, optimization techniques  
SOME keyword  
sort buffer  
soundex() function  
speed
       MySQL server
               compiling and linking for   2nd   3rd  
SQL
       statements
               CREATE DATABASE   2nd  
               CREATE TABLE   2nd   3rd   4th   5th   6th   7th   8th  
               DELETE   2nd   3rd   4th   5th   6th   7th  
               INSERT   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th  
               REPLACE   2nd  
               SELECT   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th   20th   21st   22nd   23rd   24th   25th   26th   27th   28th   29th   30th   31st   32nd   33rd   34th   35th   36th   37th   38th   39th   40th   41st   42nd   43rd  
               TRUNCATE   2nd  
               UPDATE   2nd   3rd   4th  
SQL (Structured Query Language)  
sql-bench directory  
sqrt() function  
SSL (Secure Sockets Layer)   2nd  
START TRANSACTION command  
starting
       MySQL server   2nd   3rd  
starting slaves   2nd   3rd  
statement
       ON
               GRANT statement  
statements
       ALTER TABLE  
       DROP TABLE  
       FLUSH PRIVILEGES   2nd  
       GRANT   2nd   3rd   4th   5th  
               IDENTIFIED BY clause  
               On clause  
               ON clause  
               REQUIRE clause  
               TO clause  
               WITH clause  
               WITH GRANT OPTION clause  
       LOAD DATA INFILE   2nd   3rd   4th   5th   6th   7th   8th  
       LOCK TABLES  
       REVOKE
               privileges  
       SELECT
               table creation  
       SET
               variables, setting   2nd  
       show processlist
               threads  
       show variables  
       SQL
               CREATE DATABASE   2nd  
               CREATE TABLE   2nd  
               DELETE   2nd   3rd   4th   5th   6th   7th  
               INSERT   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th  
               REPLACE   2nd  
               SELECT   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th   20th   21st   22nd   23rd   24th   25th   26th   27th   28th   29th   30th   31st   32nd   33rd   34th   35th   36th   37th   38th   39th   40th   41st   42nd   43rd  
               TRUNCATE   2nd  
               UPDATE   2nd   3rd   4th  
       SQL CREATE TABLE   2nd   3rd   4th   5th   6th  
       UNLOCK  
       use
               database selection   2nd  
statements.   [See also commands]
static MyISAM tables   2nd   3rd   4th  
std() function  
stop words
       full-text searching  
STRCMP function  
       string comparison   2nd   3rd  
string and text column types
       BLOB   2nd  
       CHAR   2nd   3rd  
       ENUM  
       SET  
       TEXT   2nd  
       VARCHAR  
string functions
       string comparison  
               LIKE function   2nd   3rd   4th  
               MATCH function  
               RLIKE function   2nd   3rd   4th   5th   6th  
               STRCMP function   2nd   3rd   4th  
       string processing   2nd   3rd   4th   5th  
Structured Query Language (SQL)  
subdate() function  
subqueries  
       Boolean expression   2nd   3rd   4th   5th   6th  
       derived table   2nd   3rd  
       single-value   2nd   3rd  
       types of  
substring() function  
subtraction (-) operator  
sum() function  
SUPER privilege  
superkeys
       candidate keys  
       defined  
switches
       -h