mysql 去除字段后面0 的函数

DELIMITER $$DROPFUNCTIONIFEXISTSud{f}_{r}emov{e}_{e}n{d}_{z}ero$$

CREATE
FUNCTION udf_remove_end_zero (i_int_srt varchar(50) – 数值字符串
)
RETURNS varchar(50) CHARSET utf8
COMMENT ‘去除数值字符串末尾的0’
BEGIN
DECLARE result varchar(50) DEFAULT ‘’;
DECLARE v_nums int;
DECLARE tmp_str varchar(1);

SET result = i_int_srt;
SET v_nums = LENGTH(i_int_srt);
SET tmp_str = SUBSTRING(i_int_srt, v_nums, 1);
WHILE tmp_str = ‘0’ DO
SET result = SUBSTRING(i_int_srt, 1, v_nums - 1);
SET v_nums = v_nums - 1;
SET tmp_str = SUBSTRING(i_int_srt, v_nums, 1);
END WHILE;

RETURN result;
END
$$