S

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]

security
     network access, disabling
     passwords, setting
     privileges
         allowing other users to grant
         ALTER
         ALTER ROUTINE
         CREATE
         CREATE ROUTINE
         CREATE USER 2nd
         CREATE VIEW
         DELETE
         DROP
         EXECUTE
         FILE
         FLUSH PRIVILEGES command
         granting
         INDEX
         INSERT
         LOCK TABLES
         PROCESS
         RELOAD
         REPLICATION CLIENT
         REPLICATION SLAVE
         revoking
         SELECT
         SHOW DATABASES
         SHOW VIEW
         SHUTDOWN
         SUPER
         UPDATE
         USAGE
         viewing
     SSL-secured connections
     user authentication, disabling
SELECT command
     AS keyword
     DISTINCT clause
     INSERT…SELECT
     INTO DUMPFILE clause
     INTO OUTFILE clause
     JOIN keyword
     joins
     LIKE operator
     LIMIT clause
     ORDER BY clause
     users, finding
SELECT privilege
servers
     connecting to
     crashes
     tasks
SET clause (UPDATE command)
SET PASSWORD command
SHOW CREATE TABLE command
SHOW DATABASES command 2nd
SHOW DATABASES privilege
SHOW GRANTS command
SHOW TABLES command 2nd
SHOW VIEW privilege
SHUTDOWN privilege
skip-grant-tables option (my.cnf file)
skip-networking option (my.cnf file)
sorting result sets
SSL-secured connections
storage engines
storing data in tables
     AUTO_INCREMENT columns
     data from other tables
     date/time
     INSERT command
         date/time, adding
         multiple rows, adding
         syntax
     INSERT...SELECT command
     LOAD DATA INFILE command
     multiple rows
     optimization tips
subqueries
     correlated subqueries
     filtering with
     selecting results of
SUPER privilege