MySQL Cheat Sheets

The MySQL cheat sheet is designed to act as a reminder and reference sheet, listing useful information about MySQL. It includes a list of the available functions in MySQL, as well as data types. It also includes a list of MySQL functions available in PHP, and a list of useful sample queries to select data from a database. A description of what is on the cheat sheet follows, or if you are impatient, you can go straight to the full size MySQL cheat sheet:

Here are the most commonly used SQL commands and the most commonly used options for each. There are many more commands and options than listed here. In other words, the syntaxes as I have listed them are far from complete. See the links at the bottom for more complete syntaxes and more commands.

A cheat sheet and quick reference guide for MySQL Commands.

A Handy Cheat-Sheet of MySQL Commands and a great quick reference guide.

Portions of the following are quoted from the MySQL web site. Observations and opinions expressed below may be useful to MySQL™ newbies (use this information at your own risk).

MySQL Cheat Sheet and quick reference guide.

MySQL is a small, fast and highly configurable DBMS. It supports a number of different table fileformats, depending on the requirements of the user.

Basic mysql operations that are helpful to have written down.

Want to translate or compare mysql with mssql? Here's a reference I got recently.

MySQL Cheat Sheet and quick reference guide

This MySQL cheatsheet is the first of a series of cheatsheets. I’ve always set up cheatsheets for my own use as long as I’ve been writing programs, which goes back a long time. What sets this cheatsheet apart from others is that it focuses on commonly used MySQL examples and not just code. It’s a free download. I hope that you find it to be useful.

or if you are impatient

MySQL Injection Cheat Sheet and quick reference guide.

A Mysql cheat sheet and quick reference guide.

This is a list of handy MySQL commands that I use time and time again. At the bottom are statements, clauses, and functions you can use in MySQL. Below that are PHP and Perl API functions you can use to interface with MySQL. To use those you will need to build PHP with MySQL functionality. To use MySQL with Perl you will need to use a Perl module.

Scripty Goddess : Mini MySQL Cheat Sheet and quick reference guide.

WikiBook : MySQL Cheat Sheet From Wikibooks, the open-content textbooks collection