Skip to Main Content
Learn SQL using MySQL in One Day and Learn It Well
book

Learn SQL using MySQL in One Day and Learn It Well

by Jamie Chan
April 2024
Intermediate to advanced content levelIntermediate to advanced
127 pages
2h 29m
English
Packt Publishing
Content preview from Learn SQL using MySQL in One Day and Learn It Well

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

MySQL Crash Course

MySQL Crash Course

Rick Silva

Publisher Resources

ISBN: 9781836205678Supplemental Content