Create Functions and Drop Functions structure

MySQL Generator

Create Functions - Structure

Functions Name

Functions Parameters(Optional)

Functions Return

Functions Body

Delimiter

Query Output:

CopiedCopy Code

DELIMITER $$
CREATE FUNCTION <function_name>(param1 VARCHAR(10),param2 CHAR(6) )
RETURNS VARCHAR(25) NON DETERMINISTIC
BEGIN
<function body>
//RETURN CONCAT('Hello, ',param1,' ',param2);
END $$;
DELIMITER

Examples:

CopiedCopy Code

DELIMITER $$
CREATE FUNCTION getDetails(name VARCHAR(30), genderType CHAR(1) )
RETURNS VARCHAR(45) NON DETERMINISTIC
BEGIN
DECLARE gender VARCHAR(6) DEFAULT 'Female';
IF(genderType='M') THEN
SET gender='Male';
END IF;
RETURN CONCAT('Hello, ',name,' ',gender);
END $$;
DELIMITER;

Drop Function - Structure

Function Name

Query Output:

CopiedCopy Code

DROP FUNCTION IF EXISTS <function_name>;