mysql函数语法

mysql创建函数语法练习：

*mysql创建函数时，返回varchar需要给定字符集


DELIMITER $$  
DROP FUNCTION IF EXISTS F_GET_STATUS_NAME $$  
CREATE FUNCTION F_GET_STATUS_NAME( in_status VARCHAR(255),in_language VARCHAR(255)) RETURNS VARCHAR(4) CHARACTER SET utf8 COLLATE utf8_general_ci 
BEGIN  
DECLARE status_name VARCHAR(4) CHARACTER SET utf8 COLLATE utf8_general_ci; 


IF (in_status = ' ') 
AND (in_language =  ‘ ') THEN


SET status_name = ' ';


ELSEIF  (in_status = ' ') 
AND (in_language = ' ')  THEN


SET status_name = ' ';


END IF;


RETURN status_name;  


END $$  
DELIMITER ;