Chapter 6: Selecting Data Part 2
In the previous chapter, we learned quite a few keywords that we can use to select data from our tables.
In this chapter, we’ll learn to use built-in functions in our SELECT statements.
What is a Function?
First off, what is a function?
A function is a block of code that does a certain job for us. For an analogy, think of the mathematical functions available in MS Excel. To add numbers, we can use the sum() function and type sum(A1:A5) instead of typing A1+A2+A3+A4+A5.
A function in MySQL is similar; it helps us accomplish certain tasks more easily.
MySQL provides us with a large number of pre-written functions that we can use in our SQL statements.
The full list of MySQL functions can be found ...
Get Learn SQL using MySQL in One Day and Learn It Well 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.
