MySQL Functions

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