“How to create functions in MySQL?”

2 years ago
Liam
1 minute

To create a function in MySQL, you can use the CREATE FUNCTION statement. Here is an example of creating a function:

CREATE FUNCTION 函数名(参数1 数据类型, 参数2 数据类型, ...) RETURNS 返回值数据类型
BEGIN
    -- 函数体逻辑
    DECLARE 变量1 数据类型;
    DECLARE 变量2 数据类型;
  
    -- 执行逻辑操作
    
    -- 返回结果
    RETURN 结果;
END;

In this case, the function name is a custom name, with parameters like parameter 1 and parameter 2 being the inputs of the function, while the return value data type represents the type of the function’s output.

Here is a simple example of creating a function to calculate the sum of two numbers:

CREATE FUNCTION AddNumbers(a INT, b INT) RETURNS INT
BEGIN
    DECLARE result INT;
    SET result = a + b;
    RETURN result;
END;

This creates a function called AddNumbers, which takes two integers as input parameters and returns their sum.

bannerAds