MySQL Phrasebook

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