Syntax of create function with Definer rights in MySQL

Create function with Definer rights in MySQL

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 ;

Leave a Reply