2021-07-23

创建 mysql函数

模板如下（示例）：

BEGIN
DECLARE sendMoney decimal(7,2);
IF(orderCode = ‘’ OR orderCode IS null)
THEN
SET sendMoney = 0.00;
ELSE
SET sendMoney =
(SELECT sum(tdt.send_price)
FROM
tb_distribution_time tdt
WHERE
tdt.order_code = orderCode
AND tdt.is_send = 1);
END IF;
RETURN (sendMoney);
END