8 Calling Built-in MySQL Functions

MySQL has hundreds of prewritten functions that perform a variety of tasks. In this chapter, you’ll review some common functions and learn how to call them from your queries. You’ll work with aggregate functions, which return a single value summary based on many rows of data in the database, and functions that help perform mathematical calculations, process strings, deal with dates, and much more.

In Chapter 11, you’ll learn to create your own functions, but for now you’ll focus on calling MySQL’s most useful built-in functions. For an up-to-date list of all the built-in functions, the best source is the ...

Get MySQL Crash Course now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.