MySQL - Useful Functions

---

Here is the list of all important MySQL functions. Each function has been explained along with suitable example.

• MySQL Group By Clause − The MySQL GROUP BY statement is used along with the SQL aggregate functions like SUM to provide means of grouping the result dataset by certain database table column(s).

• MySQL IN Clause − This is a clause, which can be used along with any MySQL query to specify a condition.

• MySQL BETWEEN Clause − This is a clause, which can be used along with any MySQL query to specify a condition.

• MySQL UNION Keyword − Use a UNION operation to combine multiple result sets into one.

Build in MySQL Functions

• MySQL DATE and Time Functions − Complete list of MySQL Date and Time related functions.

• MySQL Numeric Functions − Complete list of MySQL functions required to manipulate numbers in MySQL.

• MySQL String Functions − Complete list of MySQL functions required to manipulate strings in MySQL.

• MySQL Aggregate Functions − Complete list of MySQL aggregate functions.