Create a function

suggest change

DELIMITER $$
CREATE
    DEFINER=`db_username`@`hostname_or_IP`
    FUNCTION `function_name`(optional_param data_type(length_if_applicable))
    RETURNS data_type
BEGIN
    /*
    SQL Statements goes here
    */
END$$
DELIMITER ;

The RETURNS data_type is any MySQL datatype.

Found a mistake? Have a question or improvement idea? Let me know.

Table Of Contents