O'Reilly logo

MySQL, Second Edition: Visual Quickstart Guide by Larry Ullman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

6. MySQL Functions

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.

Text Functions

The first group of functions I will demonstrate ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required