Function - (MariaDB Advance)

In MariaDB, a function is a procedure that returns a value. It is a reusable code block that can be called from other parts of a program. Functions can be used to simplify code and make it easier to read and maintain.

Syntax

The syntax for creating a function in MariaDB is as follows:

CREATE FUNCTION function_name (parameters) 
RETURNS return_data_type 
BEGIN 
    -- function body 
END;

Here, function_name is the name of the function, parameters are the input parameters for the function, return_data_type is the data type of the value returned by the function, and function body is the code block that performs the function's computation.

Example

Here is an example of a simple function in MariaDB that returns the sum of two numbers:

CREATE FUNCTION add_numbers(num1 INT, num2 INT) 
RETURNS INT 
BEGIN 
    DECLARE result INT;
    SET result = num1 + num2;
    RETURN result;
END;

SELECT add_numbers(5, 10) AS result;

Output

The output of the above code will be:

+--------+
| result |
+--------+
|     15 |
+--------+

Explanation

In the above example, we have created a function called add_numbers that takes two input parameters of type INT. Inside the function, we have declared a variable called result of the same type, INT. We have then computed the sum of the input parameters, assigned the result to the variable, and returned the variable as the output of the function.

The function is then called using the SELECT statement to compute the sum of 5 and 10.

Use

Functions can be used in MariaDB to simplify code and make it easier to read and maintain. They can be called from other parts of a program, reducing code duplication and increasing code reuse. Functions can also be used to perform complex computations or data manipulations.

Important Points

• A function in MariaDB is a procedure that returns a value.
• Functions are created using the CREATE FUNCTION statement.
• Functions take input parameters and return a value of a specified data type.
• Functions can be used to simplify code and perform complex computations.

Summary

In summary, a function in MariaDB is a reusable code block that takes input parameters and returns a value. Functions can be created using the CREATE FUNCTION statement and can be used to simplify code, reduce code duplication, and improve code reuse. They are a powerful tool for performing complex computations and data manipulations.