MYSQL in a Nutshell (In a Nutshell (OReilly))

Index

[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-mode option (mysqld) --safe-recover option (myisamchk)

--safe-show-database option (mysqld)

--safe-user-create option (mysqld) SAVEPOINT statement 2nd 3rd SCALE attribute (Perl DBI)searching     data 2nd

     mailing list archives SEC_TO_TIME( ) function 2nd 3rdSECOND interval     DATE_ADD( ) function

     TIMESTAMPADD( ) function

SECOND( ) function --secure option (mysqld) secure socket layer (SSL) variables

--secure-auth option (mysqld)

SELECT INTO...OUTFILE statementSELECT privilege (GRANT/REVOKE)

     description     example 2nd     LOAD DATA FROM MASTER statement

     LOAD TABLE...FROM MASTER statement

SELECT statement

     ALTER VIEW statement and

     analyzing data     commas and

     creating views

     EXPLAIN statement and     granting privileges for

     inserting rows based on 2nd     JOIN clause     mysql_affected_rows( ) and

     mysql_fetch_field( ) and 2nd

     mysql_fetch_lengths( ) and

     mysql_fetch_rows( ) and

     mysql_field_count( ) and

     mysql_num_rows( ) and 2nd

     nesting

     ORDER BY clause

     RIGHT( ) function

     ROLLBACK statement and

     SQL_CALC_FOUND_ROWS flag

     syntax

     UNION keyword

     UTC_DATE( ) function

     UTC_TIME( ) function

     UTC_TIMESTAMP( ) function

SELECT...UNION clause (SELECT) 2nd selectall_arrayref( ) function (Perl DBI)

selectall_hashref( ) function (Perl DBI)

selectcol_arrayref( ) function (Perl DBI) selectrow_array( ) function (Perl DBI) selectrow_arrayref( ) function (Perl DBI) selectrow_hashref( ) function (Perl DBI) 2nd semicolon (;)

SEPARATOR flag (GROUP_CONCAT) SERIALIZABLE option (SET TRANSACTION)SESSION flag     SET statement

     SET TRANSACTION statement

     SHOW VARIABLES statement SESSION_USER( ) function 2nd 3rd SET AUTOCOMMIT statement

SET clause (INSERT) 2nd 3rd

SET datatype 2nd SET DEFAULT flag (CREATE TABLE)

SET GLOBAL statement 2nd SET NULL flag (CREATE TABLE) SET PASSWORD statement

SET SQL_LOG_BIN statement

SET statement

     AUTOCOMMIT value and

     increasing variable values     setting AUTOCOMMIT

     setting variables 2nd

     syntax     variables and

SET TRANSACTION statement --set-auto-increment option (myisamchk) --set-character-set option (myisamchk)

--set-variable option

     mysql program

     mysqld program

set_err( ) function (Perl DBI) 2nd 3rd

SHA( ) function 2nd

SHA1( ) function 2nd

--shared-memory option (mysqld)

--shared-memory-base-name option (mysqld)

--short-form option (mysqlbinlog)

SHOW BINLOG EVENTS statement

SHOW CHARACTER SET statement 2nd

SHOW COLLATION statement 2nd

SHOW COLUMNS statement 2nd

SHOW CREATE DATABASE statement

SHOW CREATE TABLE statement

SHOW CREATE VIEW statement 2nd SHOW DATABASE statement 2nd

SHOW DATABASES privilege (GRANT/REVOKE)

SHOW DATABASES statement 2nd SHOW ENGINES statement SHOW ERRORS statement SHOW FULL COLUMNS statement SHOW GRANTS statement

SHOW INDEX statement 2nd 3rd 4th 5th SHOW INNODB STATUS statement SHOW LOGS statement SHOW MASTER LOGS statement 2nd 3rd 4th

SHOW MASTER STATUS statement 2nd

SHOW PRIVILEGES statement SHOW PROCESSES statement SHOW PROCESSLIST statement 2nd 3rd

SHOW SLAVE HOSTS statement

SHOW SLAVE LOGS statement SHOW SLAVE STATUS statement 2nd 3rd

SHOW STATUS statement SHOW TABLE statement SHOW TABLE STATUS statement 2nd 3rd 4th 5th

SHOW TABLE TYPES statement

SHOW TABLES statement 2nd 3rd

SHOW VARIABLES statement 2nd 3rd 4th

SHOW VIEW privilege (GRANT/REVOKE) SHOW WARNINGS statement 2nd 3rd 4th 5th

ShowErrorStatement attribute (Perl DBI)

shutdown command (mysqladmin) shutdown option (mysqladmin) 2nd 3rd 4th

SHUTDOWN privilege (GRANT/REVOKE) --shutdown_timeout option (mysqladmin) SIGN( ) function

SIGNED flag

SIGNED INTEGER datatype 2nd

--silent option

     myisamchk utility

     myisampack utility

     mysql program

     mysqladmin utility

     mysqlcheck utility

     mysqlimport utility

SIN( ) function

sine 2nd

--single-transaction option (mysqldump)

--skip-bdb option (mysqld)

--skip-comments option (mysqldump)

--skip-concurrent-insert option (mysqld)

--skip-delay-key-write option (mysqld) --skip-external-locking option (mysqld)

--skip-grant-tables option (mysqld)

--skip-host-cache option (mysqld) --skip-innodb option (mysqld) --skip-isam option (mysqld) --skip-locking option (mysqld) 2nd --skip-log-warnings option (mysqld)

--skip-name-resolve option (mysqld) --skip-ndbcluster option (mysqld) --skip-networking option (mysqld) --skip-new option (mysqld)

-skip-opt option (mysqldump)

--skip-quote-names option (mysqldump) --skip-safemalloc option (mysqld) --skip-show-database option (mysqld)

--skip-stack-trace option (mysqld) 2nd

--skip-symlink option (mysqld) --skip-thread-priority option (mysqld)

SLAVE option (RESET) --sleep option (mysqladmin) 2nd 3rd SMALLINT datatype 2nd

--socket option

     mysql program

     mysqladmin utility

     mysqlcheck utility     mysqld program

     mysqld_safe program

     mysqldump utility     mysqlhotcopy utility

     mysqlimport utility     mysqlshow utility Solaris environment 2nd

--sort-index option (myisamchk) 2nd

--sort-records option (myisamchk) 2nd

--sort-recover option (myisamchk) 2nd

SOUNDEX( ) function

source distribution 2nd 3rd

SPACE( ) function

--spassword option (mysqlaccess)

SPATIAL indexes 2nd 3rd

--sql-mode option (mysqld)

SQL_BIG_RESULT flag (SELECT)

SQL_BUFFER_RESULT flag (SELECT)

SQL_CACHE_FOUND_ROWS flag (SELECT)

SQL_CALC_FOUND_ROWS flag (SELECT)

SQL_NO_CACHE flag (SELECT)

SQL_SMALL_RESULT flag (SELECT)

SQL_THREAD keyword (START SLAVE) SQRT( ) function

square root

SSL (secure socket layer) variables standard deviation START SLAVE statement 2nd 3rd START TRANSACTION statement 2nd 3rd 4th 5th 6th --start-date option (mysqlbinlog)

--start-position option (mysqlbinlog) 2nd start-slave command (mysqladmin) state attribute (Perl DBI) state( ) function (Perl DBI)

Statement attribute (Perl DBI) 2nd

statement handles, attributes for 2nd status command (mysqladmin) --status option (mysqlshow)

STD( ) function 2nd

STDDEV( ) function 2nd STOP SLAVE statement 2nd

--stop-date option (mysqlbinlog) --stop-position option (mysqlbinlog) stop-slave command (mysqladmin)

storage engines

     BDB

     displaying status

     InnoDB     listing

     MySQL support

     NDB Cluster 2nd     tables as

STORAGE keyword (SHOW ENGINES) STR_TO_DATE( ) functionSTRAIGHT_JOIN flag

     JOIN clause

     SELECT statement

STRCMP( ) function

string datatypes 2nd

string functions

SUBDATE( ) function

SUBSTRING( ) function 2nd 3rd 4th

SUBSTRING_INDEX( ) function

SUBTIME( ) function 2nd

--sufix option (mysqlhotcopy)

SUM( ) function 2nd

Sun environment 2nd

SUPER privilege (GRANT/REVOKE) 2nd 3rd 4th

--superuser option (mysqlaccess)

symbolic links 2nd

--symbolic-links option (mysqld) SYSDATE( ) function

SYSTEM_USER( ) function 2nd 3rd