MYSQL ( Lesson No. XV )

MYSQL Useful Functions and Clauses

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

• mysql/mysql-group-by-clause.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/mysql-in-clause.MySQL IN Clause - This is a clause which can be used alongwith any MySQL query to specify a condition.
• mysql/mysql-between-clauseMySQL BETWEEN Clause - This is a clause which can be used alongwith any MySQL query to specify a condition.
• mysql/mysql-union-keywordMySQL UNION Keyword - Use a UNION operation to combine multiple result sets into one.
• mysql/mysql-count-functionMySQL COUNT Function - The MySQL COUNT aggregate function is used to count the number of rows in a database table.
• mysql/mysql-max-functionMySQL MAX Function- The MySQL MAX aggregate function allows us to select the highest (maximum) value for a certain column.
• mysql/mysql-min-functionMySQL MIN Function- The MySQL MIN aggregate function allows us to select the lowest (minimum) value for a certain column.
• mysql/mysql-avg-functionMySQL AVG Function - The MySQL AVG aggregate function selects the average value for certain table column.
• mysql/mysql-sum-functionMySQL SUM Function - The MySQL SUM aggregate function allows selecting the total for a numeric column.
• mysql/mysql-sqrt-functionMySQL SQRT Functions - This is used to generate a square root of a given number.
• mysql/mysql-rand-functionMySQL RAND Function- This is used to generate a random number using MySQL command.
• mysql/mysql-concat-functionMySQL CONCAT Function- This is used to concatenate any string inside any MySQL command.
• mysql/mysql-date-time-functionsMySQL DATE and Time Functions - Complete list of MySQL Date and Time related functions.
• mysql/mysql-numeric-functionsMySQL Numeric Functions- Complete list of MySQL functions required to manipulate numbers in MySQL.