CBSE Class 11 Informatics Practices Functions in MySQL

Functions in MySQL

Single-row functions: Single row functions operate on a single value to return a single value. They can accept one or more arguments but return only one result per row. When applied on a table, they return a single result for every row of the queried table. They are

further categorized into:

Numeric functions

String functions

Date and Time functions

Multiple Row Functions (also called Aggregate Functions):Multiple row functions operate on a set of rows to return a single value. Examples include SUM(), AVG() and COUNT().

Let us consider the following table named Employee with 5 rows. We will be referring to it in our lesson to learn about Functions.

A) Numeric Functions: MySQL numeric functions perform operations on numeric values and return numeric values. The following table tells us about the numeric functions of MySQL and what they do.

B) String( Character) Functions :String functions operate on character type data. String functions are used to extract, change, format or alter character strings. They return either character or numeric values. The following table tells us about the Character functions of MySQL and what they do.

C) Date and Time Functions: Date and Time functions allow us to perform many types of tasks on Date type data.The default date format in MySQL is YYYY-MM-DD.

Summary

1. Functions perform some operations and return a value.

2. Single row functions operate on a single value to return a single value.

3. Multiple Row functions operate on a set of rows to return a single value.

4. Numeric functions perform operations on numeric values and return numeric values.

5. String functions operate on character type data. They return either character or numeric values.

6. Date and Time functions allow us to manipulate Date type data.

Please refer to the link below - CBSE Class 11 Informatics Practices Functions in MySQL