SELECT and WHERE clauses
CREATE DATABASE syntax
DROP DATABASE syntax
CREATE TABLE syntax
ALTER TABLE syntax
DROP TABLE syntax
OPTIMIZE TABLE syntax
CHECK TABLE syntax
REPAIR TABLE syntax
DELETE syntax
SELECT syntax
JOIN syntax
INSERT syntax
REPLACE syntax
LOAD DATA INFILE syntax
Importing data from text files
UPDATE syntax
USE syntax
FLUSH syntax (clearing caches)
KILL syntax
SHOW syntax (Get information about tables, columns,...)
EXPLAIN syntax (Get information about a SELECT)
DESCRIBE syntax (Get information about columns)
BEGIN/COMMIT/ROLLBACK syntax
LOCK TABLES/UNLOCK TABLES syntax
SET syntax
GRANT and REVOKE syntax
CREATE INDEX syntax
DROP INDEX syntax
CREATE FUNCTION/DROP FUNCTION syntax