This section gives you the most commonly used MySQL functions including aggregate functions, string functions, date-time functions, control flow functions, etc.
MySQL Aggregate Functions
Aggregate functions allow you to perform a calculation on a set of records and return a single value. In this tutorial, you will learn various MySQL aggregate functions including SUM, AVG, MAX, MIN and COUNT functions.
MySQL Comparison Functions
In this section, you will learn about the comparison functions in MySQL including COALESCE, GREATEST, LEAST, and ISNULL.
MySQL Control Flow Functions and Expressions
The control flow functions allow you to add if-then-else logic to SQL queries without using the procedural code.
MySQL Date Functions
This page shows you the most commonly used MySQL Date Functions that allow you to manipulate date and time data effectively.
MySQL String Functions
This page lists MySQL string functions that allow you to manipulate strings effectively.
MySQL Window Functions
This tutorial provides you with some practical and motivational examples of the window functions.
MySQL Math Functions
This page explores the most frequently used MySQL mathematical functions with practical & real world examples.
