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 ;