SQL Reference
Naming Conventions
Functions and Operators
Comparison Operators
Logical Operators
Arithmetic Operators
String Concatenation Operator
String Functions
Mathematical Functions
Date Functions
Aggregate Functions
Data Conversion Functions
System Functions
Conditional Expressions
SQL Commands
SELECT Command
Subqueries
INSERT Command
UPDATE Command
DELETE Command
CREATE TABLE Command
ALTER TABLE Command
DROP TABLE Command
TRUNCATE TABLE Command
CREATE INDEX Command
DROP INDEX Command
START TRANSACTION Command
COMMIT Command
ROLLBACK Command
Appendix
Maximum Capacity Specifications
Field Data Types
Reserved Words
SQL Reference courtesy ComponentAce