MySQL - Useful Functions

Here is the pst 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 pke 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 pst of MySQL Date and Time related functions.

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

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

MySQL Aggregate Functions − Complete pst of MySQL aggregate functions.