Skip Navigation

Find cheat sheets for every topic, or make your own to share with your friends.

All Added Bytes cheat sheets are available free at Cheatography!

Visit Cheatography »

MySQL Cheat Sheet

A quick reference guide for MySQL, including functions (both in MySQL and PHP), data types, and sample queries. Available in PDF and PNG formats.

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:

Functions in MySQL

Thumbnail highlighting mysql functions. Many developers are completely unaware that MySQL actually has a huge number of functions built in, to do everything from regular expression-based string comparisons to complicated mathematical calculations. The outsides of the cheat sheet list MySQL functions (note: a few of the more unusual and least used functions have not been included due to constraints of space).

MySQL Data Types

Thumbnail highlighting data types section. MySQL allows for many data types for columns, and it is very easy to forget what constraints there are on these data types. This is especially important when it comes to validation - many developers do not check the length of data before inserting it into a table. This section lists the data types available and their constraints.

MySQL Functions in PHP

Thumbnail highlighting mysql function in PHP. PHP has a MySQL module and this is used by most PHP developers to connect to, and query, a MySQL database. This section lists the functions available in PHP for connecting to and managing a MySQL database.

Sample Queries

Thumbnail highlighting sample queries list. Finally, the cheat sheet includes a short list of sample queries and a brief explanation of each.

Download

So now that you know what it does, please feel free to print out the MySQL cheat sheet:

Please note: If you wish to link to the MySQL cheat sheet from elsewhere, please link to this page so others find the description, rather than linking directly to the sheet.

And finally, if you like the cheat sheets, and want to say thanks, please consider buying me something from my Amazon Wishlist. Thankyou very much to those who have already hunted it down and sent me something nice - I'm very grateful!

Related Cheat Sheets

No documents found.


comments powered by Disqus