MySQL has dozens of built-in functions that are designed to simplify common tasks. I’ll cover the most useful ones here, but don’t be surprised if you find that MySQL has added others in newer versions of the software. In my personal opinion, it’s the functions that make querying a database so useful (SQL by itself is too vanilla).
Most of the functions you’ll learn in this chapter are used in conjunction with SQL queries to format and alter the returned data. As in the preceding chapter, every example will be demonstrated from within the
mysql client. Each example will be based upon the existing accounting database and be used to illustrate common database techniques.
The first group of functions I will demonstrate ...