此存储的函数将单个int转换为base26：
DROP FUNCTION IF EXISTS `base10to26`;
DELIMITER ;;
CREATE FUNCTION `base10to26`(`theNumber` INT(11) UNSIGNED)
RETURNS VARCHAR(20) READS sql DATA
BEGIN
DECLARE colTxt VARCHAR(20);
DECLARE value INT(11);
SET colTxt = '';
REPEAT
SET value = theNumber % 26;
IF value = 0 THEN SET value = 26; END IF;
SET theNumber = (theNumber - value) / 26;
SET colTxt = CONCAT(CHAR(value+64), colTxt);
UNTIL theNumber = 0 END REPEAT;
RETURN colTxt;
END;;
DELIMITER ;
602392714
清零编程群