Uncover the hidden capabilities of MySQL with these 10 power tips

This document looks under the hood to introduce you to some of the less well-known capabilities of MySQL.

While MySQL is certainly a well-known and very popular database, it also has a history marked by innovation and evolution of its code base. It is inevitable that some features and capabilities have been added without being noticed by even the most accomplished users. This download takes a look at some MySQL features that you may not have noticed previously, but can definitely find a use for in the future, including:

• Viewing query results in XML
• Compressing tables
• Conditional SQL, and
• Modifying the command prompt

This document lists a few lesser-known MySQL capabilities, what other MySQL features would you like to see explored?

This download is also available as a TechRepublic article.