/*这里需要将分号转成竖号,已区分结束符*/
delimiter |
CREATE
DEFINER=`root`@`%`
EVENT `EveryBill`
ON SCHEDULE EVERY 1 DAY
STARTS '2020-01-01 00:10:00' ENDS '2030-01-01 00:10:00'
ON COMPLETION
PRESERVE ENABLE
DO
BEGIN
CALL CalBill();
Call CalShipBill();
END |
/*这里转回结束符为分号*/
delimiter ;
MYSQL多语句事件
最新推荐文章于 2024-07-24 16:11:19 发布