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

safe_mysqld script
    option groups used 
safe_mysqld script.  [See mysqld_safe script]2nd  [See mysqld_safe script]
safe_mysqld.  [See mysqld_safe]
safe_show_database variable 
sampdb database distribution
    obtaining  2nd 
sample database  2nd  3rd  4th  5th 
    creating  2nd  3rd 
    grade-keeping project example  2nd  3rd 
        table creation  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th 
    naming conventions 
    obtaining 
    requirements  2nd 
    tables
        deleting records  2nd  3rd 
        inserting records  2nd  3rd  4th  5th  6th 
        retrieving records  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  44th  45th  46th  47th  48th  49th  50th  51st  52nd 
        updating records  2nd 
    U.S. Historical League example  2nd  3rd  4th  5th  6th 
        table creation  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th 
scalar data types
    C API  2nd 
SCALE attribute
    Perl DBI API 
scheduling
    log file expiration  2nd 
scheduling queries
    optimization  2nd  3rd 
scientific notation 
scope columns (grant tables)
    contents of  2nd  3rd 
    matching order  2nd 
        privilege problem example  2nd  3rd  4th 
scope-of-access columns (grant tables)  2nd 
score browser example
    Web-based applications  2nd  3rd  4th  5th 
scores.  [See student scores example]
scp access
    selecting ISPs 
scripts
    server connections via  2nd 
scripts.  [See Perl DBI API, PHP API]2nd  [See Perl DBI API]
searches.  [See indexes]
searching example
    Web-based applications  2nd  3rd  4th  5th  6th  7th 
SEC_TO_TIME() function 
SECOND() function 
security  2nd  3rd  4th 
    database browser example
        Web-based applications  2nd 
    external security  2nd  3rd 
        avoiding grant table risks  2nd  3rd 
        grant table structure  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th 
        modifying grant tables  2nd  3rd 
        privilege problem example  2nd  3rd  4th 
        stages of access control  2nd  3rd  4th  5th  6th  7th  8th  9th 
    hidden fields (PHP) 
    internal security  2nd  3rd 
        for data directory  2nd  3rd  4th  5th 
        for option files  2nd 
        for socket file  2nd 
        reasons for implementing  2nd 
    login authentication
        PHP API  2nd  3rd  4th  5th  6th  7th 
    of grant tables  2nd 
        initial setup  2nd  3rd 
        setting passwords  2nd  3rd 
    passwords
        encryption 
        load_defaults() function 
        log file security 
        on command line 
        resetting root password  2nd 
        setting for additional servers  2nd 
        setting for anonymous accounts 
        setting for root account  2nd  3rd 
    permissions
        for data directory 
    privacy of user-specific option files 
    privileges
        displaying available 
        granting  2nd  3rd  4th 
        of anonymous accounts 
        revoking  2nd 
    privileges.  [See privileges]
    server security
        from Web-based applications  2nd  3rd  4th  5th 
    SSL connections  2nd  3rd  4th 
    SSL support
        in client programs  2nd  3rd  4th 
    SSL.  [See SSL]
    Windows root accounts 
security functions  2nd  3rd  4th  5th  6th 
security issues
    selecting ISPs  2nd 
SELECT privilege  2nd  3rd 
SELECT statement  2nd  3rd  4th  5th  6th 
    creating tables from  2nd  3rd  4th 
    joining together  2nd 
    joins  2nd 
        full joins  2nd 
        left and right joins  2nd  3rd  4th 
        trivial joins  2nd 
    retrieving records  2nd  3rd  4th 
        calculating columns with expressions  2nd 
        from multiple tables  2nd  3rd  4th  5th  6th  7th  8th  9th 
        generating summaries  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
        limiting results  2nd  3rd 
        NULL value  2nd  3rd 
        pattern matching  2nd  3rd 
        restriction criteria  2nd  3rd  4th  5th 
        setting variables  2nd 
        sorting results  2nd  3rd  4th 
        with date values  2nd  3rd  4th  5th  6th  7th 
    subselects  2nd  3rd 
        rewriting as joins  2nd 
    unions  2nd  3rd  4th 
select_limit variable 
selectall_arrayref()
    Perl DBI database handle method  2nd 
    Perl DBI result sets  2nd 
selectall_hashref()
    Perl DBI database handle method  2nd 
selectcol_arrayref()
    Perl DBI database handle method  2nd 
selecting
    column types  2nd  3rd  4th 
        AUTO_INCREMENT columns 
        case sensitivity  2nd 
        indexes  2nd 
        performance issues  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
        range of values in column  2nd  3rd 
        types of values in column  2nd  3rd  4th  5th 
    columns for indexes  2nd 
    databases  2nd 
        PHP API 
    ISPS 
    ISPs 
        bandwidth considerations 
        general criteria  2nd  3rd  4th  5th  6th  7th  8th  9th 
        MySQL-specific criteria  2nd  3rd  4th 
        needs assessment  2nd 
        services provided  2nd 
    numeric types  2nd  3rd 
    table handlers  2nd 
selection criteria
    for APIs  2nd 
        development time  2nd  3rd  4th 
        execution environment  2nd 
        performance  2nd  3rd  4th  5th  6th  7th  8th 
        portability  2nd 
selectrow_array()
    Perl DBI database handle method  2nd 
    Perl DBI result sets  2nd 
selectrow_arrayref()
    Perl DBI database handle method  2nd 
selectrow_hashref()
    Perl DBI database handle method  2nd 
self-referential URLs
    CGI.pm Perl module  2nd  3rd 
semicolon ( )
    in queries  2nd 
semicolon ()
    go command 
sequences
    AUTO_INCREMENT attribute  2nd 
        adding to tables  2nd 
        BDB tables 
        forcing non-reuse of numbers 
        HEAP tables 
        InnoDB tables 
        ISAM tables  2nd  3rd 
        MyISAM tables  2nd  3rd  4th 
        resequencing columns  2nd 
        tips for  2nd  3rd 
    generating
        without AUTO_INCREMENT attribute  2nd  3rd  4th 
SERIALIZABLE option
    setting transaction isolation level 
server
    auto-recovery capabilities  2nd 
    coordinating table access for  2nd 
        with external locking  2nd 
        with internal locking  2nd  3rd  4th  5th  6th  7th  8th 
    listening for network connections  2nd 
    multiple servers  2nd  3rd  4th  5th 
        configuring  2nd 
        mysqld_multi script  2nd 
        on Windows  2nd  3rd 
        option files for  2nd  3rd 
        startup options  2nd 
    performance tuning  2nd 
        list of InnoDB-related server variables  2nd 
        list of server variables  2nd  3rd 
        setting server variables  2nd  3rd 
    restarting
        when unable to connect  2nd  3rd 
    shutdown  2nd 
        forcibly  2nd 
    startup
        option files  2nd 
        UNIX  2nd  3rd  4th  5th  6th  7th 
        Windows  2nd  3rd  4th  5th 
server cache
    query optimization  2nd 
server caches
    flushing  2nd 
server connections
    from Web-based applications  2nd  3rd  4th  5th 
    PHP API  2nd  3rd  4th  5th 
    terminating 
    troubleshooting
        uninitialized connection handler pointers  2nd 
    with C API  2nd  3rd 
server queries
    PHP API  2nd 
server security
    from Web-based applications  2nd  3rd  4th  5th 
server status variables
    displaying  2nd  3rd  4th  5th  6th  7th  8th 
server threads.  [See threads]
server variables
    query optimization  2nd 
server variables.  [See variables]
server_id variable 
servers
    Apache.  [See Apache]
    configuration and tuning
        adminstration duties 
    connections 
        creating accounts for  2nd 
        terminating 
        via mysql command  2nd  3rd  4th 
        via option files  2nd 
        via shell aliases  2nd 
        via shell history list  2nd 
    connections via Access 
    libmysqld library 
    login accounts
        creating for MySQL  2nd 
    multiple servers
        administration duties 
    mysqld  2nd 
    security 
    starting
        for MySQL installation  2nd 
        from command-line 
    starting as services 
    startup and shutdown
        administration duties 
servers.  [See also multiple servers]
service
    starting server as  2nd 
service names
    mysqld server 
services
    starting servers as 
Services Manager.  [See Windows Services Manager]
services provided
    selecting ISPs  2nd 
SESSION keyword
    displaying variables 
    setting variables  2nd 
session variables 
    setting 
SESSION_USER() function 
SET clause
    updating tables 
SET PASSWORD statement  2nd 
SET statement  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
    auto-commit mode 
SET string type  2nd  3rd  4th  5th  6th  7th  8th  9th 
SET TRANSACTION statement  2nd 
SHA() function 
SHA1() function 
shared libraries
    versus static libraries 
shell account access
    selecting ISPs 
shell aliases
    server connections via  2nd 
shell history list
    server connections via  2nd 
short-form options
    versus long-form options 
SHOW BINLOG EVENTS statement  2nd 
SHOW CHARACTER SET statement  2nd  3rd 
SHOW COLUMN TYPES statement  2nd 
SHOW COLUMNS statement  2nd  3rd 
SHOW CREATE DATABASE statement 
SHOW CREATE TABLE statement  2nd 
SHOW DATABASES privilege  2nd  3rd 
SHOW DATABASES statement  2nd  3rd 
SHOW FIELDS statement 
SHOW GRANTS statement 
SHOW INDEX statement  2nd 
SHOW INNODB STATUS statement 
SHOW KEYS statement  2nd 
SHOW LOGS statement  2nd 
SHOW MASTER LOGS statement 
SHOW MASTER STATUS statement  2nd 
SHOW OPEN TABLES statement  2nd 
SHOW PRIVILEGES statement  2nd 
SHOW PROCESSLIST statement  2nd 
SHOW SLAVE HOSTS statement  2nd 
SHOW SLAVE STATUS statement  2nd  3rd  4th  5th 
SHOW statement  2nd  3rd  4th  5th  6th 
SHOW STATUS statement  2nd  3rd  4th  5th  6th  7th  8th 
SHOW TABLE STATUS statement  2nd  3rd 
SHOW TABLE TYPES statement  2nd  3rd 
SHOW TABLES statement  2nd  3rd  4th  5th 
SHOW VARIABLES statement  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th 
    data directory location 
ShowErrorStatement attribute
    Perl DBI API 
shutdown
    server  2nd 
        forcibly  2nd 
shutdown command 
SHUTDOWN privilege  2nd  3rd 
SIGN() function 
SIN() function 
skip_external_locking variable  2nd 
skip_locking variable  2nd 
skip_networking variable 
skip_show_database variable 
SLAVE option
    flushing caches 
    resetting cache 
slave servers
    displaying information about  2nd  3rd  4th 
    master-slave replication relationship  2nd 
        setting up  2nd  3rd  4th 
    starting and stopping  2nd 
    threads 
SLAVE START statement 
SLAVE statement  2nd 
SLAVE STOP statement 
slave_net_timeout variable 
slow-query log  2nd  3rd  4th 
slow_launch_time variable 
SMALLINT numeric type  2nd 
socket file
    replacing  2nd 
    security  2nd 
socket variable 
software updates
    administration duties 
sort_buffer_size variable  2nd  3rd  4th 
sort_key_blocks variable 
sorting
    log files 
    query results  2nd  3rd  4th 
sorting order
    for scope columns (grant tables)  2nd 
        privilege problem example  2nd  3rd  4th 
SOUNDEX() function 
SOURCE command 
source command 
source MySQL distributions  2nd 
    installation  2nd  3rd 
space limitations
    selecting ISPs  2nd 
SPACE() function 
speed.  [See query optimization]
spreadsheet programs
    versus databases  2nd 
SQL
    (Structured Query Language)  2nd 
    administration uses of 
    importance of learning 
    limitations of  2nd 
    operators.  [See operators]
    pronunciation of 
    statements 
        accessing tables  2nd 
        altering databases  2nd  3rd  4th 
        altering tables  2nd  3rd  4th  5th  6th  7th  8th 
        analyzing tables  2nd 
        backing up tables  2nd  3rd  4th 
        comment styles  2nd  3rd  4th 
        committing transactions  2nd 
        creating databases  2nd  3rd 
        creating functions  2nd 
        creating indexes  2nd  3rd  4th  5th 
        creating tables  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th  18th  19th  20th 
        deleting binary update logs  2nd 
        deleting table rows  2nd 
        displaying binary log file information 
        displaying binary update log events  2nd 
        displaying binary update log file information  2nd 
        displaying character sets supported  2nd 
        displaying column type information  2nd 
        displaying columns  2nd 
        displaying CREATE DATABASE statement 
        displaying CREATE TABLE statement 
        displaying databases available 
        displaying index information  2nd 
        displaying InnoDB table information 
        displaying log file information  2nd 
        displaying privileges  2nd 
        displaying privileges available 
        displaying server status variables  2nd  3rd  4th  5th  6th  7th  8th 
        displaying slave server information  2nd  3rd  4th 
        displaying table information  2nd 
        displaying table types  2nd 
        displaying tables  2nd 
        displaying thread information  2nd 
        displaying variables  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th 
        dropping databases  2nd  3rd  4th 
        dropping functions 
        dropping indexes  2nd  3rd 
        dropping tables  2nd  3rd  4th 
        error checking tables  2nd  3rd 
        evaluating expressions  2nd 
        flushing caches  2nd 
        flushing privileges 
        full joins  2nd 
        granting privileges  2nd  3rd  4th 
        inserting rows into tables  2nd  3rd  4th 
        joining SELECT statements  2nd 
        joins  2nd 
        killing threads 
        left and right joins  2nd  3rd  4th 
        loading data  2nd  3rd  4th  5th  6th 
        locking tables  2nd  3rd  4th 
        multiple-table deletes and updates  2nd  3rd 
        naming conventions  2nd  3rd  4th  5th  6th 
        obtaining database or table information  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th 
        optimizing tables  2nd 
        renaming tables  2nd 
        repairing tables  2nd  3rd  4th  5th 
        replication servers  2nd 
        resetting cache  2nd 
        restoring tables  2nd  3rd  4th 
        retrieving rows from tables  2nd  3rd  4th  5th  6th 
        revoking privileges  2nd 
        rolling back transactions  2nd 
        selecting databases  2nd 
        setting default database 
        setting passwords 
        setting transaction isolation level  2nd 
        setting variables  2nd  3rd  4th  5th  6th 
        starting and stopping slave servers  2nd 
        subselects  2nd  3rd  4th  5th 
        transactions  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th 
        trivial joins  2nd 
        truncating tables  2nd 
        types of  2nd 
        unions  2nd  3rd  4th 
        unlocking tables 
        updating tables  2nd 
    variables
        user-defined variables  2nd 
SQL AUTO IS NULL option
    setting variables 
SQL BIG RESULT keyword
    retrieving rows from tables 
SQL BIG SELECTS option
    setting variables 
SQL BIG TABLES option
    setting variables 
SQL BUFFER RESULT keyword
    retrieving rows from tables 
SQL BUFFER RESULT option
    setting variables 
SQL CACHE keyword
    retrieving rows from tables 
SQL CALC FOUND ROWS keyword
    retrieving rows from tables 
SQL LOG BIN option
    setting variables 
SQL LOG OFF option
    setting variables 
SQL LOG UPDATE option
    setting variables 
SQL LOW PRIORITY UPDATES option
    setting variables 
SQL MAX JOIN SIZE option
    setting variables 
SQL NO CACHE keyword
    retrieving rows from tables 
SQL QUERY CACHE TYPE option
    setting variables 
SQL QUOTE SHOW CREATE option
    setting variables 
SQL SAFE UPDATES option
    setting variables 
SQL SELECT LIMIT option
    setting variables 
SQL SLAVE SKIP COUNTER option
    setting variables 
SQL SMALL RESULT keyword
    retrieving rows from tables 
SQL statements
    for table changes in data directory  2nd 
SQL THREAD option
    starting and stopping slave servers 
SQL WARNINGS option
    setting variables 
sql_mode variable 
SQRT() function 
SSL
    program options
        list of  2nd 
SSL columns (grant tables)  2nd  3rd 
SSL connections  2nd  3rd  4th 
    specifying in GRANT statement  2nd 
SSL status variables
    displaying  2nd  3rd 
SSL support
    in client programs  2nd  3rd  4th 
standalone interpreters
    versus module interpreters  2nd  3rd  4th 
standalone PHP scripts  2nd 
start-slave command 
start_html()
    CGI.pm Perl module 
starting
    server
        option files  2nd 
        UNIX  2nd  3rd  4th  5th  6th  7th 
        Windows  2nd  3rd  4th  5th 
    servers
        as services 
        for MySQL installation  2nd 
        from command-line 
    slave servers  2nd 
STARTING BY clause
    loading data 
startup options
    for multiple servers  2nd 
Statement attribute
    Perl DBI API  2nd 
statement counter status variables
    displaying 
statement handle attributes
    Perl DBI API  2nd  3rd  4th  5th  6th  7th  8th 
statement handle methods
    Perl DBI API  2nd  3rd  4th  5th  6th  7th 
statements (SQL) 
    binary log files
        displaying information about 
    binary update log files
        displaying information about  2nd 
    binary update logs
        deleting  2nd 
        displaying events  2nd 
    cache
        resetting  2nd 
    caches
        flushing  2nd 
    character sets
        displaying supported  2nd 
    comment styles  2nd  3rd  4th 
    databases
        altering  2nd  3rd  4th 
        creating  2nd  3rd 
        displaying available 
        dropping  2nd  3rd  4th 
        obtaining information about  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th 
        selecting  2nd 
        setting default 
    displaying CREATE DATABASE statement 
    displaying CREATE TABLE statement 
    expressions
        evaluating  2nd 
    functions
        creating  2nd 
        dropping 
    indexes
        creating  2nd  3rd  4th  5th 
        displaying information about  2nd 
        dropping  2nd  3rd 
    InnoDB tables
        displaying information about 
    joining SELECT statements  2nd 
    joins  2nd 
        full joins  2nd 
        left and right joins  2nd  3rd  4th 
        trivial joins  2nd 
    loading data  2nd  3rd  4th  5th  6th 
    log files
        displaying information about  2nd 
    multiple-table deletes and updates  2nd  3rd 
    naming conventions 
        case sensitivity  2nd 
        database elements  2nd  3rd 
    passwords
        setting 
    privileges
        displaying  2nd 
        displaying available 
        flushing 
        granting  2nd  3rd  4th 
        revoking  2nd 
    replication servers  2nd 
    restoring tables  2nd 
    server status variables
        displaying  2nd  3rd  4th  5th  6th  7th  8th 
    slave servers
        displaying information about  2nd  3rd  4th 
        starting and stopping  2nd 
    subselects  2nd  3rd 
        rewriting as joins  2nd 
    tables
        accessing  2nd 
        altering  2nd  3rd  4th  5th  6th  7th  8th 
        analyzing  2nd 
        backing up  2nd  3rd  4th 
        creating  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th  18th  19th  20th 
        deleting rows  2nd 
        displaying  2nd 
        displaying column type information  2nd 
        displaying columns  2nd 
        displaying information about  2nd 
        displaying types of  2nd 
        dropping  2nd  3rd  4th 
        error checking  2nd  3rd 
        inserting rows  2nd 
        inserting rows into  2nd 
        locking  2nd  3rd  4th 
        obtaining information about  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th 
        optimizing  2nd 
        renaming  2nd 
        repairing  2nd  3rd  4th  5th 
        restoring  2nd 
        retrieving rows from  2nd  3rd  4th  5th  6th 
        truncating  2nd 
        unlocking 
        updating  2nd 
    threads
        displaying information about  2nd 
        killing 
    transactions  2nd  3rd  4th  5th  6th  7th  8th 
        committing  2nd 
        non-transactional alternatives  2nd  3rd 
        reasons for using  2nd 
        rolling back  2nd 
        setting isolation level  2nd 
    types of  2nd 
    unions  2nd  3rd  4th 
    variables
        displaying  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th 
        setting  2nd  3rd  4th  5th  6th 
static libraries
    versus shared libraries 
statistics.  [See information gathering functions]
status command  2nd 
status files
    in data directory  2nd  3rd  4th  5th 
        relocating  2nd 
STATUS option
    flushing caches 
STD() function 
STDDEV() function 
stealing data
    methods for  2nd 
stop-slave command 
stopping
    slave servers  2nd 
stopping.  [See shutdown]
storage structure
    for privilege columns (grant tables)  2nd 
stored procedures
    lack of support for 
STRAIGHT JOIN keyword 
    retrieving rows from tables 
STRAIGHT JOIN statement
    forcing joins  2nd 
STRCMP() function  2nd 
string comparisons  2nd 
string concatenation 
string data types  2nd  3rd  4th 
string functions  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th 
string types  2nd  3rd  4th  5th  6th  7th  8th 
    attributes  2nd  3rd  4th 
    BLOB string type  2nd  3rd 
    CHAR string type  2nd  3rd  4th  5th  6th  7th 
    combining with numeric types  2nd 
    concatenation 
    ENUM string type  2nd  3rd  4th  5th  6th  7th  8th  9th 
    length in characters versus bytes  2nd 
    LONGBLOB string type  2nd 
    LONGTEXT string type  2nd 
    MEDIUMBLOB string type  2nd 
    MEDIUMTEXT string type  2nd 
    SET string type  2nd  3rd  4th  5th  6th  7th  8th  9th 
    size and storage requirements 
    TEXT string type  2nd  3rd 
    TINYBLOB string type  2nd 
    TINYTEXT string type  2nd 
    VARCHAR string type  2nd  3rd  4th  5th  6th  7th 
    versus numeric types  2nd 
        performance issues  2nd 
string-to-number conversion 
structural terminology for databases  2nd  3rd  4th 
Structured Query Language.  [See SQL]
structures
    C API.  [See also non-scalar data types]
structures.  [See also objects]
student scores example
    PHP API  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th 
SUBDATE() function 
SUBJECT keyword
    granting privileges 
subselects  2nd  3rd  4th  5th 
    rewriting as joins  2nd 
SUBSTRING() function 
SUBSTRING_INDEX() function 
subtraction operator (-) 
SUM() function 
    generating summaries 
summaries
    generating
        from query results  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
summary functions  2nd  3rd  4th 
SUPER privilege  2nd  3rd 
superuser privileges
    avoiding risks 
switch statement
    PHP API 
symbolic links
    data directory security 
symlinks
    data directory relocation  2nd 
        databases  2nd  3rd 
syntax
    PHP API
        similarities with other languages 
synthetic indexes 
SYSDATE() function 
system command 
system performance.  [See performance]
system requirements
    client programs  2nd 
System V-style systems
    starting server 
system variables
    setting 
SYSTEM_USER() function