Quick links to the MySQL documentation
Mon, 2010-03-15 15:50 —
oli
MySQL Statement Syntax
Data Definition Language (DDL) Statements
Data Manipulation Language (DML) Statements
| CALL | DELETE | DO | HANDLER |
| INSERT | LOAD DATA INFILE | REPLACE | SELECT |
| TRUNCATE TABLE | UPDATE |
MySQL Utility Statements
| DESCRIBE | EXPLAIN | HELP | USE |
MySQL Transactional and Locking Statements
| START TRANSACTION | COMMIT | ROLLBACK | SAVEPOINT |
| ROLLBACK TO SAVEPOINT | LOCK TABLES | UNLOCK TABLES | SET TRANSACTION |
| XA Transactions |
Account Management Statements
| CREATE USER | DROP USER | GRANT | RENAME USER |
| REVOKE | SET PASSWORD |
Table Maintenance Statements
| ANALYZE TABLE | BACKUP TABLE | CHECK TABLE | CHECKSUM TABLE |
| OPTIMIZE TABLE | REPAIR TABLE | RESTORE TABLE |
Plugin and User-Defined Function Statements
| CREATE FUNCTION | DROP FUNCTION | INSTALL PLUGIN | UNINSTALL PLUGIN |
SHOW Statements
Other Administrative Statements
| BINLOG | CACHE INDEX | FLUSH | KILL |
| LOAD INDEX INTO CACHE | RESET | SET |
Replication Statements
SQL Syntax for Prepared Statements
| PREPARE | EXECUTE | DEALLOCATE PREPARE |
MySQL Compound-Statement
MySQL Data Types
MySQL Numeric Data Types
MySQL Date and Time Data Types
| DATETIME | DATE | TIMESTAMP | TIME |
| YEAR |
MySQL String Data Types
MySQL functions
MySQL date and time functions
MySQL system variables
| general_log |
MySQL status variables
MySQL Thread States
| Sending data |
MySQL features
| Query Cache | General Query Log |
