此存储的函数将单个int转换为base26:
DROP FUNCTION IF EXISTS `base10to26`;DELIMITER ;;CREATE FUNCTION `base10to26`(`theNumber` INT(11) UNSIGNED) RETURNS VARCHAr(20) READS SQL DATABEGIN 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 ;



