SET GLOBAL event_scheduler = 1;
DROP EVENT
IF EXISTS e_clean_wallet
CREATE EVENT e_clean_wallet
ON SCHEDULE EVERY 1 MONTH STARTS DATE_ADD(DATE_ADD(DATE_SUB(CURDATE(), INTERVAL DAY(CURDATE())-1 DAY), INTERVAL 1 MONTH), INTERVAL 1 HOUR)
ON COMPLETION PRESERVE ENABLE
DO CALL p_clean_wallet();
这个建立每个月第一天的1点执行,报错“[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE EVENT e_clean_wallet
ON SCHEDULE EVERY 1 MONTH STARTS DATE_ADD(DATE_A' at line 3”
好像是说“ON SCHEDULE EVERY 1 MONTH STARTS DATE_ADD(DATE_ADD(DATE_SUB(CURDATE(), INTERVAL DAY(CURDATE())-1 DAY), INTERVAL 1 MONTH), INTERVAL 1 HOUR) ”这句有问题 请大家帮忙看看啊
DROP EVENT
IF EXISTS e_clean_wallet
CREATE EVENT e_clean_wallet
ON SCHEDULE EVERY 1 MONTH STARTS DATE_ADD(DATE_ADD(DATE_SUB(CURDATE(), INTERVAL DAY(CURDATE())-1 DAY), INTERVAL 1 MONTH), INTERVAL 1 HOUR)
ON COMPLETION PRESERVE ENABLE
DO CALL p_clean_wallet();
这个建立每个月第一天的1点执行,报错“[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE EVENT e_clean_wallet
ON SCHEDULE EVERY 1 MONTH STARTS DATE_ADD(DATE_A' at line 3”
好像是说“ON SCHEDULE EVERY 1 MONTH STARTS DATE_ADD(DATE_ADD(DATE_SUB(CURDATE(), INTERVAL DAY(CURDATE())-1 DAY), INTERVAL 1 MONTH), INTERVAL 1 HOUR) ”这句有问题 请大家帮忙看看啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货