DELIMITER $$
CREATE
/*[DEFINER = { user | CURRENT_USER }]*/
FUNCTION `t204`.`fun_1`(sex INT)
RETURNS VARCHAR(10)
/*LANGUAGE SQL
| [NOT] DETERMINISTIC
| { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
| SQL SECURITY { DEFINER | INVOKER }
| COMMENT 'string'*/
BEGIN
DECLARE a VARCHAR(10);
IF sex=0
THEN
SET a:='女';
ELSEIF sex=1
THEN
SET a:='男';
END IF;
RETURN a;
END$$
DELIMITER ;
#调用自定义函数
SELECT fun_1(1);