mysql查询数据把阿拉伯数字转中文数字

MySQL本身并不支持将阿拉伯数字转换为中文数字，需要使用自定义函数来实现。以下是一个示例函数：

DELIMITER $$

CREATE FUNCTION arabic_to_chinese(n INT) RETURNS VARCHAR(255)
BEGIN
    DECLARE result VARCHAR(255) DEFAULT '';
    DECLARE i INT DEFAULT 1;
    DECLARE len INT;
    DECLARE unit CHAR(10) DEFAULT '';
    DECLARE digit CHAR(10) DEFAULT '';
    DECLARE chn_digit CHAR(10) DEFAULT '';
    DECLARE chn_unit CHAR(10) DEFAULT '个十百千万亿';
    DECLARE chn_num CHAR(100) DEFAULT '零一二三四五六七八九';
    DECLARE chn_div CHAR(10) DEFAULT '亿万';
    IF n = 0 THEN 
        RETURN '零';
    END IF;
    IF n < 0 THEN
        SET result = '负';
        SET n = -n;
    END IF;
    SET digit = CAST(n AS CHAR);
    SET len = LENGTH(digit);
    WHILE i <= len DO
        SET unit = SUBSTRING(chn_unit, i, 1);
        SET chn_digit = SUBSTRING(chn_num, CAST(SUBSTRING(digit, i, 1) AS UNSIGNED) + 1, 1);
        IF chn_digit = '零' THEN
            IF unit IN ('万', '亿') OR (i = len AND unit = '个') THEN
                SET result = CONCAT(result, chn_digit);
            END IF;
        ELSE
            SET result = CONCAT(result, chn_digit, unit);
        END IF;
        IF i < len AND unit IN ('亿', '万') THEN
            SET result = CONCAT(result, SUBSTRING(chn_div, 1, 1));
        END IF;
        SET i = i + 1;
    END WHILE;
    RETURN result;
END$$

DELIMITER ;

使用方法：

SELECT arabic_to_chinese(123456789) AS chn_num;

输出结果：

+--------------+
| chn_num      |
+--------------+
| 一亿二千三百四十五万六千七百八十九 |
+--------------+