mysql金额转换函数

SELECT CONCAT('$', amount) AS formatted_amount FROM transactions;

SELECT ROUND(amount, 2) AS rounded_amount FROM transactions;

SELECT FORMAT(amount, 2) AS formatted_amount FROM transactions;

ALTER TABLE transactions MODIFY COLUMN amount DECIMAL(10, 2);

DELIMITER $$
CREATE FUNCTION AddThousandSeparator(num DECIMAL(10, 2)) RETURNS VARCHAR(255)
BEGIN
    DECLARE str VARCHAR(255);
    SET str = CAST(num AS CHAR);
    SET str = REPLACE(str, ',', '');
    SET str = FORMAT(str, 2);
    RETURN CONCAT(str, ',');
END$$
DELIMITER ;