4.1. Statements Grouped by Type

The following is a quick list of SQL statements grouped by type. Some statements are listed in more than one group, because they have more than one use relative to the groups listed.

4.1.1. Data Manipulation

DELETE, DO, HANDLER, INSERT, JOIN, LOAD DATA INFILE, REPLACE, SELECT, SELECT...UNION, TRUNCATE, UPDATE, USE

4.1.2. Database and Table Schema

ALTER DATABASE, ALTER TABLE, ALTER VIEW, CREATE DATABASE, CREATE INDEX, CREATE TABLE, CREATE VIEW, DROP DATABASE, DROP INDEX, DROP TABLE, DROP VIEW, RENAME TABLE

4.1.3. Database and Table Properties

DESCRIBE, SHOW CHARACTER SET, SHOW COLLATION, SHOW COLUMNS, SHOW CREATE DATABASE, SHOW ENGINES, SHOW ERRORS, SHOW GRANTS, SHOW INDEX, SHOW INNODB STATUS, SHOW LOGS, SHOW PRIVILEGES, SHOW PROCESSLIST, SHOW STATUS, SHOW TABLE STATUS, SHOW TABLES, SHOW VARIABLES, SHOW WARNINGS

4.1.4. Table Administration

ANALYZE TABLE, BACKUP TABLE, CACHE INDEX, CHECK TABLE, CHECKSUM TABLE, LOAD INDEX INTO, OPTIMIZE TABLE, REPAIR TABLE, RESET, RESTORE TABLE, SET, SHOW INDEX, SHOW TABLE STATUS

4.1.5. User Administration

DROP USER, GRANT, REVOKE, SET PASSWORD, SHOW GRANTS, SHOW PRIVILEGES, FLUSH

4.1.6. Server Administration

SET, SHOW ENGINES, SHOW ERRORS, SHOW INNODB STATUS, SHOW LOGS, SHOW PROCESSLIST, SHOW STATUS, SHOW VARIABLES, SHOW WARNINGS, FLUSH, KILL

4.1.7. Replication

CHANGE MASTER TO, LOAD DATA FROM MASTER, PURGE MASTER LOGS, RESET SLAVE, RESET MASTER, SET GLOBAL SQL_SLAVE_SKIP_COUNTER, SET SQL_LOG_BIN, SHOW BIN_LOG_EVENTS, SHOW MASTER LOGS, SHOW MASTER STATUS, SHOW SLAVE HOSTS, SHOW SLAVE STATUS, START SLAVE, STOP SLAVE