DELIMITER $$
USE mypos
$$
DROP FUNCTION IF EXISTS pysxcx
$$
CREATE DEFINER=root
@localhost
FUNCTION pysxcx
(zw VARCHAR(50)) RETURNS VARCHAR(10) CHARSET utf8mb4
DETERMINISTIC
BEGIN
SET @pysx=‘’;
SET @len=CHAR_LENGTH(zw);
SET @i=1;
WHILE @i<=@len DO
SET @hz=SUBSTR(zw,@i,1);
SELECT jp INTO @jp FROM hzpyb WHERE hz=@hz;
SET @pysx=CONCAT(@pysx,@jp);
SET @i=@i+1;
END WHILE;
RETURN @pysx;
END$$
DELIMITER ;