We just released an updated version of our popular free MySQL Cheat Sheet, which is a very useful reference resource for any programmer who works with the MySQL database or PHP.

This new version (1.1) includes references for many issues that programmers deal with whenever they work on applications involving the MySQL database. The cheat sheet saves you time because you no longer have to look up the proper syntax for MySQL queries.

We also include some of our best tips and tricks for streamlining your MySQL applications. We believe that when writing web applications you should adhere to Albert Einstein’s famous quote, “Keep everything as simple as possible, but never simpler.”

Please see our Free MySQL Cheat Sheet Download Page to download your copy.

The new cheatsheet covers the following topics:

• MySQL Data Types
• Data Column Attributes
• Common Table Alteration Commands
• Setting Up a MySQL Connection
• 3 Ways to Insert a New Row
• How to Update an Existing Row
• How to Set Up a Natural Language Full-Text Search
• How to Set Up a Simple Boolean Full-Text Search
• A Method to Loop Through Rows in a MySQL Database
• Commonly Used MySQL Functions
• MySQL One-Line Commands

As always, if you see something that is missing or may be incorrect, let us know by submitting a reply.