MySQL Ref is a quick reference for the most commonly used SQL commands for the MySQL database. If you are experienced with MySQL, use it as a quick reference guide, or if you are a student or just learning SQL it can be a valuable tool to help the learning process. All of the data is contained within the application, no internet connection is required.
The SQL commands are separated into the following groups:
Data Types
Table Cmds
Select
Insert
Update
Delete
Join
Views
Aggregate Functions
Date Functions
Math Functions
String Functions
Each detail sheet contains Syntax, Description and Example sections. Sample code is supplied for each detail sheet.