App Shopper: MySQL Cheat Sheet (Reference)

App Activity

Jun 26 '09	Version 1.0.1
Mar 11 '09	New App: $.99, v1.0

About AppShopper

For more information on Contacting Us, App Submissions, and Advertising, visit our About page

MySQL Cheat Sheet

iOS iPhone

Even seasoned web developers need a quick refresher course in MySQL syntax from time to time. The MySQL Cheat Sheet for iPhone and iPod Touch is designed to address that need. Use it as a quick reference for topics you’ve already learned but need a few reminders on, or if you’re still a beginner to MySQL, use it to better understand what MySQL has to offer.

This is a native app, not just a link out to internet references. It's searchable and has an easy to use interface that helps you quickly find what you're looking for. The categories are useful and well defined. The cheatsheet includes:

* Command line tools (basics, msql2mysql, mysql, mysqladmin, mysqlcheck, etc.)
* Data Types - Numerics (bigint, bit, decimal, double, etc)
* Data Types - Strings (char, longtext, mediumtext, etc)
* Data Types - Dates (Date, datetime, time, timestamp, etc)
* Data Types - Binary (binary and varbinary)
* Data Types - Complex (enum and set)
* SQL - Literals (string, bit, boolean, decimal, hex, etc)
* SQL - Identifiers (absolute naming, relative naming and aliasing)
* SQL - Comments
* SQL - Common Commands
* Operators (rules or precedence, arithmetic, comparison and logical)
* Almost 250 Common Functions
* and many more

Unlike apps that cobble together random references from the web, this cheatsheet is written and reviewed by professional web developers that use MySQL on a daily basis. We keep up with changing specifications and provide free updates in the same simple, easy to use format.

Works offline for study on the go!