mysql客户端安装后如何设置函数_mysql客户端自定义函数创建方法

GRANT CREATE ROUTINE ON *.* TO 'your_user'@'localhost';
FLUSH PRIVILEGES;

SET GLOBAL log_bin_trust_function_creators = 1;

[mysqld]
log_bin_trust_function_creators=1

DELIMITER $$
<p>CREATE FUNCTION calculate_discount(price DECIMAL(10,2), rate TINYINT)
RETURNS DECIMAL(10,2)
READS SQL DATA
DETERMINISTIC
BEGIN
DECLARE discount DECIMAL(10,2);
SET discount = price * (rate / 100.0);
RETURN discount;
END$$</p><p>DELIMITER ;</p>
                    <div class="aritcle_card">
                        <a class="aritcle_card_img" href="/ai/783">
                            <img src="https://img.php.cn/upload/ai_manual/000/000/000/175679966563718.png" alt="智谱AI开放平台">
                        </a>
                        <div class="aritcle_card_info">
                            <a href="/ai/783">智谱AI开放平台</a>
                            <p>智谱AI大模型开放平台-新一代国产自主通用AI开放平台</p>
                            <div class="">
                                <img src="/static/images/card_xiazai.png" alt="智谱AI开放平台">
                                <span>85</span>
                            </div>
                        </div>
                        <a href="/ai/783" class="aritcle_card_btn">
                            <span>查看详情</span>
                            <img src="/static/images/cardxiayige-3.png" alt="智谱AI开放平台">
                        </a>
                    </div>
                

SELECT calculate_discount(200.00, 15); -- 返回 30.00

SELECT product_name, price, calculate_discount(price, 10) AS savings FROM products;

SHOW FUNCTION STATUS WHERE Db = 'your_database';

DROP FUNCTION IF EXISTS calculate_discount;