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 3rd SECOND interval DATE_ADD( ) function TIMESTAMPADD( ) function SECOND( ) function --secure option (mysqld) secure socket layer (SSL) variables --secure-auth option (mysqld) SELECT INTO...OUTFILE statement SELECT 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( ) function STRAIGHT_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 |