自定义函数:传入值(0显示值为女,1显示值为男)
DELIMITER $$
CREATE
/*[DEFINER = { user | CURRENT_USER }]*/
FUNCTION `person`.`pro_person2`(sex1 INT)
RETURNS VARCHAR(50)
/*LANGUAGE SQL
| [NOT] DETERMINISTIC
| { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
| SQL SECURITY { DEFINER | INVOKER }
| COMMENT 'string'*/
BEGIN
DECLARE sex2 VARCHAR(50)
DEFAULT '';
IF sex1=1
THEN
SET sex2:='男';
ELSEIF sex1=0
THEN
SET sex2='女';
END IF;
RETURN sex2;
END$$
DELIMITER ;
调式:
SELECT fun_person(1);